SQL Server Performance Forum – Threads Archive
SQL Server restore failureHi all, I schedule a complete backup every night and now I’ve reformatted the
server and failed to restore the backup. From the newly formatted SQL Server, it didnt contain any backup
history of the database. I’ve tried restoring by specifying the
location of the file, but still no avail. I’ve even tried the "attach" function, but I still can’t. I
desperately need some help here. Thanks.
What was the error while restoring the backup?
If the disk configuration of the previous SQL server and this one is different then you must use WITH MOVE clause in RESTORE statement, using books online. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
RESTORE FILELISTONLY FROM DISK = '\sharedirectoryfile.bak' --This will give you logical file names for the old databases. RESTORE DATABASE database_name FROM DISK = '\sharedirectoryfile.bak' WITH STATS = 1, MOVE 'logical_data_file' TO 'c:mssqldatafile_data.bak', --This will be the logical from first statement and new location. MOVE 'logical_log_file' TO 'c:mssqllogfile_log.bak' --This will be the logical from first statement and new location. If you get an error when you are doing this, let us know exactly what you typed and the exact error. MeanOldDBA [email protected] When life gives you a lemon, fire the DBA.