This post is more than 5 years old
68 Posts
0
3052
May 10th, 2012 23:00
Restore Sql database the same server with diffirent name.
Hello All,
I am looking for the way to restore sql database the same server with renaming it. I checked the documents but cant find such like this configuration. Could you please help me? I want to use it for testing puposes.
No Events found!
CarlosRojas
1.7K Posts
0
May 13th, 2012 01:00
Hi,
This option is not supported. Please see below the limitations, specially the last line (highlighted in bold):
The following are not supported:
◆ Directed recovery of:
• Filestream database
• Transparent Data Encryption (TDE) enabled database
• SQL Data Protection Manager (DPM)
• SQL Express
◆ Cross-platform directed recovery
For examples, directed recovery of SQL databases on Windows 2003 cannot be
recovered to Windows 2008 and vice versa.
◆ Directed recovery to:
• Encrypted target
• Compressed drive
Although recovery takes place, the database attachment fails.
◆ Directed recovery from SQL system databases.
◆ Alternate recovery on the same or separate location.
Also, validation of recovery target paths is not available. When a path is selected, the NMM GUI does not validate if the path is valid. The path validation is done only after recovery is started.
So I'm afraid that you will need to restore in a different server and perform steps provided in documentation for Directed Restore.
The only option is if you have the SQL tab enabled in NMM Gui. If you do then you can set the path in there (only in the SQL tab, setting a path in the NetWorker tab will lead to a failure in the restore).
Thank you.
Carlos.
ahmetkececiler
68 Posts
0
May 11th, 2012 00:00
I am using NMM module and backup sql with sql writer.
ahmetkececiler
68 Posts
0
May 11th, 2012 00:00
Here is my client config
Save Set
APPLICATIONS:\SqlServerWriter\ABPROD\ABP
Backup Command : nsrsnap_vss_save.exe
Applicatiom info : NSR_SNAP_TYPE=vss
vishwanathkrish
75 Posts
0
May 11th, 2012 00:00
Hello,
Can you please let me know the Networker module you are using to backup the SQL database .
Regards,
Vish
ble1
4 Operator
•
14.3K Posts
0
May 13th, 2012 19:00
NMM does not support it due to VSS I believe... this is one more reason why I still use NMSQL which uses VDI interface and works perfect. I really hope next NMM release will include VDI interface have ability for customers to choose which method they wish to use.
roberts26
2 Posts
0
October 7th, 2012 06:00
Make use of repair database sql corrupted by viruses, all sorts of malware, hard drive failures, file system errors, incorrect user actions, etc.