Restoring a Database to a New Server Installation.
Hello Everyone,
I am fairly new to SQL server and its functions so please bear with me. Recently we have suffered a failed raid configuration, wiping out our entire database server. Fortunately we have both Database and Log file backups that we would like to restore to a different install that runs on a different domain, obviously containing a different login and permissions setup.
Currently what is occurring when I make an attempt to restore from the .bak file is the following, error:
Cannot open backup device 'c:\(backup directory to file here)' Operating System Error 5(Access is Denied.).
RESTORE FILELIST is terminating abnormally.(Microsoft SQL Server, Error: 3201)
Would anyone know of a way to possibly work around this?
Thanks in advance
Thank you for the propmt reply.
After reading your insight on the issue I configured the proper rights for the Sql Server Service account on the server. Although your assumption of the directory structure changing from the original server is correct. Am I SoL so to speak, unless I go ahead and redo the structure to mimic that of the previous install? What I would like to do this time around if possible is adopt the directory structure changes that SQL Server 2005 has brought to us. I have referred to KB article 224071 although it seems only doable from the actual .mdf and .ldf files , not the .bak files.
Thanks again.
Hi,
not within the restore process you can provide new paths to the destination folder for the database files and the logfiles. The paths are originally read from the backup media, but can be "rediretced" to any other location than the stored ones.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
