Have Geek Brain

Error restoring sql database from .bak file

When I restore a SQL database using Microsoft SQL Server Management Studio, it fails and gives me this message:

restore error http://www.freeimagehosting.net/uploads/b464beb9ec.jpg

TITLE: Microsoft SQL Server Management Studio

Recovery failed for server 'app1'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=RestoreI+Server&L47

------------------------------ ADDITIONAL INFORMATION:

When an exception occurs, a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The file or filegroup "SilosFollow_log" could not be selected for this operation. RESTORE DATABASE ends abnormally. (Microsoft SQL Server, Error: 3219)

For help click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3219&LinkId=20476

------------------------------ BUTTONS:

OK

NB The owner of the database is not the username of the backup.

+1


source to share


2 answers


When setting up a restore, make sure you are not using the data / log files that are in use in the current database (possibly the database you are restoring on top).



This makes the data directory a mess, but when restoring the databases, I provide the data / log files with the Rev. number, so I don't face this issue.

+1


source


Are you sure SilosFollow_log is a database backup and not a transaction log backup?



To restore transaction log backups, you must first restore a full database backup and any differential backups. Then you can restore the transaction log backups one by one.

+1


source






More articles:


All Articles