Options
Restore wizard -- location of mdf and ldf
colby
Posts: 30
Need your help
I am rebuilding a new server and am restoring backups from an old server to this new server and have some questions.
a) When I use the wizard to "create" database approach, why does the wizard not know where are the SQL server defined default database locations. It seems to put them in the install default folders and not the SQL server defined folders. Why I "can not" change the location of the databases?
b) When I use the "replace" database approach again why does the wizard not know where are the SQL defined default locations? Why "can" I then change the location?
In either approach I need for it to install in the defined SQL location and have the option to change the location if needed.
c) Is there a preferred approach to use?
thanks
Colby
I am rebuilding a new server and am restoring backups from an old server to this new server and have some questions.
a) When I use the wizard to "create" database approach, why does the wizard not know where are the SQL server defined default database locations. It seems to put them in the install default folders and not the SQL server defined folders. Why I "can not" change the location of the databases?
b) When I use the "replace" database approach again why does the wizard not know where are the SQL defined default locations? Why "can" I then change the location?
In either approach I need for it to install in the defined SQL location and have the option to change the location if needed.
c) Is there a preferred approach to use?
thanks
Colby
Comments
but either way, I just copy & paste SQL Backup's restore script, and modify it on my own (find & replace)
DBA, MCITP
Somewhere along the line SQL Backup had been changed to use default data and log folders configured in the SQL Server area of the registry. I'd assume that this was done to prevent restoring to an invalid folder. At any rate, the information about how to set your default data and log folders is in our knowledge base.