sql server 2005 - Error when restore sql database from .bak file -


When I restore the SQL database using Microsoft SQL Server Management Studio, it fails and this message TITLE: Microsoft SQL Server Management Studio

The restoration server failed for 'APP1' (Microsoft.SqlServer.Smo). )

For help, click:

---------------------------- - Additional information:

Transact-SQL While executing the udder or batch exception occurred. (Microsoft.SqlServer.ConnectionInfo)


The file or file group "SilosFollow_log" can not be selected for this operation. Restore database is abnormally terminated (Microsoft SQL Server, Error: 3219)

For help, click:

----------- ----------- -------- Button:

OK

The NB database owner is not a backup user name.

When you configure a restore, make sure that you do not use data / log files There are currently running databases (maybe the databases you are restoring to the top).

This makes the data directory a mess, but I assign my data / log files to a rev-number when I restore the database so I have not run into that problem.


Comments

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -