Solved

SQL query

Posted on 2013-12-10
5
211 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: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.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
In this Micro Tutorial viewers will learn how to restore their server from Bare Metal Backup image created with Windows Server Backup feature. As an example Windows 2012R2 is used.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

777 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