Alter database into Recovery mode Sql Server

Hello ,

I have a 2 sql servers one on site and the other offsite , they are both currently at the same state as both been restored with same bak file. I want to be able to on the onsite database make some transactions then take a Log File Backup and the use that TRN file to restore on the other site. If the database is in NonRecovery Mode , how do i get it into Recovery mode without having to to a restore of bak file?

Thanks
deanmachine333Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
You can't do it without restoring a full backup first.
And because transactions are sequential you can't restore a transactional backup without restoring all the previous transactions backups that you may have.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Just run the restore command with recovery option:
RESTORE DATABASE YourDatabaseNameHere  WITH RECOVERY

Open in new window

0
 
deanmachine333Author Commented:
Hello ,

thanks for response but the database is in RECOVERY MODE , i ment to get get the database in NORECOVERY MODE so i will be able to apply the Log File ( TRN ) - So need it non-operational

cheers
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
deanmachine333Author Commented:
Thanks for reply , ok was just checking there was not a way to get the database into NORECOVERY mode without doing a full backup.

cheers
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Not doing a full backup but restoring from a full backup. It's always the first step from a restore. And NORECOVERY is not the default option so you always need to add that option to the restore command.
0
 
deanmachine333Author Commented:
Hiya , yep i know how to do that i was looking for a way to put the database in nonrecovery with out doing restore from backup.

cheers
0
All Courses

From novice to tech pro — start learning today.