Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Re: Applying tr...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 6 of 11 Topic 11172 of 11517
Post > Topic >>

Re: Applying tranaction log to old data file

by koszuf@[EMAIL PROTECTED] Jun 25, 2008 at 05:49 AM

> As Erland said, you need to first backup the transaction log with
> NO_TRUNCATE. =A0For example:
>
> BACKUP LOG MyDatabase
> TO DISK =3D 'C:\MyDatabase_Log.bak'
> WITH NO_TRUNCATE;

Thanks for your response, but how can I make log backup, if my
transactiong log is not mounted. Should I restore old backup, manually
copy current transaction log and then create log backup or there is
other procedure?
 




 11 Posts in Topic:
Applying tranaction log to old data file
koszuf@[EMAIL PROTECTED]   2008-06-24 07:01:47 
Re: Applying tranaction log to old data file
Ed Murphy <emurphy42@[  2008-06-24 07:35:00 
Re: Applying tranaction log to old data file
Erland Sommarskog <esq  2008-06-24 21:06:35 
Re: Applying tranaction log to old data file
koszuf@[EMAIL PROTECTED]   2008-06-24 23:53:05 
Re: Applying tranaction log to old data file
"Dan Guzman" &l  2008-06-25 06:41:14 
Re: Applying tranaction log to old data file
koszuf@[EMAIL PROTECTED]   2008-06-25 05:49:26 
Re: Applying tranaction log to old data file
"Dan Guzman" &l  2008-06-25 21:06:59 
Re: Applying tranaction log to old data file
Sybaseguru <collap@[EM  2008-06-26 18:56:00 
Re: Applying tranaction log to old data file
"Dan Guzman" &l  2008-06-26 19:53:27 
Re: Applying tranaction log to old data file
Erland Sommarskog <esq  2008-06-26 21:54:58 
Re: Applying tranaction log to old data file
"Dan Guzman" &l  2008-06-26 19:55:10 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 0:55:13 CST 2008.