TSQL code for backing up translog ? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

TSQL code for backing up translog ?

Hello,
Do you have to have a device setup to backup a trans log? I tried: to disk ‘c:ackup.trn’ and": to ‘c:ackup.trn’ and both failed. Thanks
J
Yes, you need to execute sp_addumpdevice first. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
If it is a backup device such as tape then you need to add the device first using Frank’s reference, if its the file then you can use
BACKUP DATABASE dbname TO DISK=’C:ackup.trn’ WITH INIT
and chekc books online for more information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>