Cuma

SQL server Restore Error

I got this error when trying to restorea database from the SQL Server Management Studio..



An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The media family on device '\\tup03srv32\Backup\SQL\tup03srv06\WSS_Content_backup_201006100000.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

Then I run the restore command via Query Editor and it worked!


RESTORE DATABASE [WSS_Content] FROM DISK = N'\\Tup03srv32\backup\SQL\tup03srv06\WSS_Content_backup_201006100000.bak' WITH FILE = 1, MOVE N'WSS_Content' TO 'c:\evrak\WSS_Content.mdf', MOVE N'WSS_Content_log' TO N'C:\evrak\WSS_Content.ldf', NOUNLOAD, REPLACE, STATS = 10 GO





Hiç yorum yok:

Yorum Gönder