May 2, 2007 at 11:40 pm
Hi, hope you can help me.
I'm trying to restore a full backup of a 600MB database that was made by data protector. the backup spans 2 tapes.
The restore fails, and I can't tell why.
I'm restoring the database to another server, machine and path, so am using the with move option, (or at least puching the buttons that generate that).
Data protector tells me its running:
SQL statement:
RESTORE DATABASE [SPS01_Content_Train_DB] FROM
VIRTUAL_DEVICE = "Data Protector_(DEFAULT)_SPS01_Content_DB_13_37_11"
WITH REPLACE, RECOVERY, MOVE "SPS01_Content_DB_Sys" TO "J:\mssql\data\SPS01_Content_DB.MDF",MOVE "SPS01_Content_DB_log" TO "J:\mssql\data\SPS01_Content_DB.LDF";
But then reports that :
From: OB2BAR_Main@dwh-srvrdr.nibdom.com.au "(DEFAULT)" Time: 5/3/2007 3:08:55 PM
Error has occurred while executing a SQL statement.
Error message: '
[Microsoft][ODBC SQL Server Driver][SQL Server]File 'SPS01_Content_DB_Sys' cannot be restored to 'J:\mssql\data\SPS01_Content_DB.MDF'. Use WITH MOVE to identify a valid location for the file.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating abnormally.'
I've checked that path is ok. I can actually see that the database files have been created.
SSMS lists the database as (Restoring ...)
Does anyone know how to get the database online, or how to restore this database successfully or how to work out what the problem is.
thanks in advance
Martin
May 3, 2007 at 1:10 am
since thats database with a size of just 600MB i advise u to restore the database backup from tape to the local disk then try restoring the database from the disk it should do good.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply