I can not restore my backup

Navigation
1

I made a backup once and it worked. Now more tables have been created, views w wc and I need to update the database. As the bank is in a network address and for security, we can not do anything, the manager here made a backup for me to install in my localhost and to be able to trap at home. Well, I can not restore. Give this error always, when I opt for device. See the error:

IfIoptforDatabase,itgivesthiserror:

What happens is I can not clear the area, that is, I already added another backup, with another name, but it always searches the old one. How do I do it?

    
asked by anonymous 26.09.2014 / 14:34

2 answers

1

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

From the State group you change Restricted access to SINGLE_USER

Then just do the restore again.

The following image:

    
26.09.2014 / 15:02
0

Pnet, for the first screen, the error informs you that your exclusive access attempt was not possible. This happens, as long as there are one or more open sessions, in the bank 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 can not have any open sessions, either by driver or by session of Management Studio.

If you have any open session, kill with kill <spid

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

Return afterwards, saying whether or not you could restore the base.

    
30.09.2014 / 09:12
Linq returns result, but does not obey join How do I put a count in a linq that returns a list