| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2011-07-21 : 21:19:46
|
| We have a database which is going to be in the current instance and needs to be moved to another server. All ok.After taking the backup from current location and moved .BAK file to new server and being created there. All ok.But I want to make the current (Old) server this database to be set as in RESTORING MODE.How can I change the decommissioned server's database into RESTORING MODE.Many Thanks for your advise. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-21 : 21:54:23
|
| Restoring so that no one can use it, or restoring so that you can apply log backups to it?--Gail ShawSQL Server MVP |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-07-21 : 22:01:38
|
| Thanks Gail.I want to see like this.Database_name (Restoring...)I am not aware of how this can be done in RESTORING... modeThe idea is to not to make this database in functionality but in the event if requires should be made Available by rreturning to NORMAL.Many Thanks Gail. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-21 : 23:09:45
|
| Backup log <db name> to disk = 'somewhere' WITH NORECOVERY--Gail ShawSQL Server MVP |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-07-21 : 23:22:16
|
| The database is in SIMPLE recovery mode and unable to perform.Any solution. Many Thanks. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-22 : 05:59:17
|
| Why do you specifically want to make it restoring? why not offline?--Gail ShawSQL Server MVP |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-07-27 : 19:25:55
|
| Since we have 2 environments like Cluster Servers and Logshipping based Primary to Standby nature.When the databases have migrated from Clustering environment to Primary Server on the Logshipping, the databases were Changed to IN RESTORING MODE on the Cluster Server and later we have deleted as it were no more required.Now,The reason for asking to make the database IN RESTORING MODE (apart from making it OFFLINE) how can this be made on Cluster OR any other Environment of server nature.Thanks All. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-28 : 06:43:01
|
| If you just want the databases unusable, take them offline. There doesn't sound like there's any valid reason to take them into restoring in your scenario.--Gail ShawSQL Server MVP |
|
|
|
|
Into Restoring Mode