Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Restoring Expand / Collapse
Author
Message
Posted Thursday, July 4, 2013 3:09 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 9, 2016 1:51 AM
Points: 824, Visits: 1,029
Hi All,

How to set Database restoring mode to normal mode?

Thanks,
RR
Post #1470351
Posted Thursday, July 4, 2013 3:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, June 23, 2016 2:47 PM
Points: 2,852, Visits: 3,341
Just execute a restore command with the RECOVERY option.
RESTORE DATABASE [{databasename}] WITH RECOVERY



** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1470355
Posted Thursday, July 4, 2013 3:47 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 9, 2016 1:51 AM
Points: 824, Visits: 1,029
Thanks for your reply, it is working.

thanks.
Post #1470372
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse