Solved

SQL query

Posted on 2013-12-10
5
205 Views
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?
0
Comment
Question by:jmanishbabu
5 Comments
 
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.
0
 
LVL 10

Author Comment

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

Accepted Solution

by:
Lee Savidge earned 500 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.
0
 
LVL 32

Expert Comment

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

Expert Comment

by:ScottPletcher
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.
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

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.
In this article I will describe the Copy Database Wizard 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.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

758 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now