SQL query

Posted on 2013-12-10
Medium Priority
Last Modified: 2014-01-26
When we copy the Database Datafiles (after SQL server is shutdown gracefully) from the source to the target DB instance, is there a way we can bring up the DB in the “restoring” state to allow us to apply additional transaction log files?
Question by:jmanishbabu
LVL 25

Expert Comment

by:Lee Savidge
ID: 39708340
If you're just copying the database files, I wouldn't do that. Just do a backup and restore.
LVL 10

Author Comment

ID: 39708346
Is there any way if the  DB in the “restoring” state to allow us to apply additional transaction log files?
LVL 25

Accepted Solution

Lee Savidge earned 1500 total points
ID: 39708362
Not that I am aware of. When moving db files form one server to another, you either detach a reattach or do a back up and restore. If you back it up, it will commit the transaction logs to the database backup and when you restore it will all be there and it will start creating its own transaction logs as you use it.
LVL 32

Expert Comment

by:Ephraim Wangoya
ID: 39708403
Backup and Restore with no recovery. Then you can continue restoring transaction log backups from the source server.
LVL 70

Expert Comment

by:Scott Pletcher
ID: 39709102
>> copy database files from source to target instance, can we [then] bring up the DB in the “restoring” state? <<

No; there is absolutely no way to do that.

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
Measuring Server's processing rate with a simple powershell command. The differences in processing rate also was recorded in different use-cases, when a server in free and busy states.
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

627 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