Networker SQL Mod Restore of Database

Question

When restoring a database to another SQL server (Lab machine) only "copy" option can be used. This renames the windows external name ie:
TestDB.mdf , TestDB_log.LDF TO:
TestDB_TestDB_2345.mdf , TestDB_TestDB_log_2345.LDF

HOWEVER, when the database is attached to SQL and listed (through the Mgmt Studio) the original name TestDB shows as the name of the DB.

Our SQL Admin is complaining about this lengthening of the name. I can understand, however as I am not a DB admin I cannot assist with how to change this. When I looked up renaming a DB I find only references to SQL Commands such as ALTER DATABASE, TSQL. When I tested the GUI rename (2005) I found the name within the SQL engine same as original name, (as referred to above).

I have been told by our very knowledgeable EMC 'Health Check' person, "restoring to another 'test server' is a very good practice", (we were doing this prior to our healthcheck anyway). I am hesitant to do a Normal restore to the original server as I want to avoid problems that can accompany that procedure.

Any suggestions from experienced persons much appreciated.

lguinane · Answer

In the SQL BSM, if you go into restore options -> can you rename the files here or restore them to another location, maybe by doing this they wont be renamed when restored.

curta99 · Answer

Are you talking about the Networker User for SQL Server? If so, you cannot rename, it names the copy according to it's own convention.

Danne-Murphy · Answer

In NetWorker for SQL Server, after you select the database, right click and select properties. Select the files tab and select the database file at the bottom of the window, The Destination button activates and you can change the file name in that window as well as the folder to restore the database.

curta99 · Answer

I tried this and yes it worked for the .mdf file, however the _log.LDF is restored with the problematic naming convention to the default directory on the lab server instead of the same directory as chosen for the .mdf.
Does this mean I can detach the database and delete the _log file and then restore the _log only??? or will this corrupt the whole thing?

I don't mind doing it as a 2 step process, just need to know it will play well when completed.

NetWorker

Networker SQL Mod Restore of Database

Was this post helpful?