I can’t restore my backup

Asked

Viewed 1,731 times

1

I backed it up once and it all worked out. Now more tables, views w wtc have been created and I need to update the database. As the bank is at a network address and for security, we have no way to do anything, the manager here made a backup for me to install on my localhost and trample at home. Well, I can’t restore. Give this error always, when I choose device. See the error: inserir a descrição da imagem aqui

If I choose Database, gives this error:

inserir a descrição da imagem aqui

What happens is I can’t clear the area, IE, I’ve already added another backup, with another name, but it always searches the old one. As I do?

sql-server sql-server-2012 backup

  • First question: this backup that the manager made is consistent?

2 answers

1


Pnet, tries to right-click the database and select the Options.

Thence within the group State you change the Restricted access for SINGLE_USER

So just do the restoration again.

Follow picture: inserir a descrição da imagem aqui

0

Pnet, for the first screen, the error informs that your exclusive access attempt was not possible. This happens, when there are one or more sessions open, in the bank that you try to overwrite. A simple and quick way to find out if it exists is to run the command below:

SELECT * FROM sys.sysprocesses WHERE dbid = DB_ID('[nome_base]')

Important: You may not have any session open, either by driver or by Management Studio session.

If you have an open session, kill with a kill <spid

For the second screen, the error is very quiet. It simply says that, the backup file you are trying to use, has not been located (Operating System error 2).

Returns later, saying whether or not he was able to restore the base.

Browser other questions tagged sql-server sql-server-2012 backup

You are not signed in. Login or sign up in order to post.