Solved

Alter database into Recovery mode Sql Server

Posted on 2014-09-05
6
267 Views
Last Modified: 2014-09-05
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
0
Comment
Question by:deanmachine333
  • 3
  • 3
6 Comments
 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 40305423
Just run the restore command with recovery option:
RESTORE DATABASE YourDatabaseNameHere  WITH RECOVERY

Open in new window

0
 

Author Comment

by:deanmachine333
ID: 40305430
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
 
LVL 48

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40305477
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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

Author Comment

by:deanmachine333
ID: 40305487
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
 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 40305493
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
 

Author Comment

by:deanmachine333
ID: 40305502
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

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
domain login has permission in database, but gets error 3 18
How to debug a store procedure in MS SQL 2008? 3 23
SQL DATEADD 10 70
Amazon RDS migrate to SQL Server 3 24
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question