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
Post a Comment