SQL Server Performance Forum – Threads Archive
Dump log file
I need to make dump of my transaction file. Can you help me Thanks Roulette Methods Life in www.theroulettexperts.com John Goitiwww.therouletteexperts.com
Use below command and edit database_name and Path of file to be placed.. BACKUP LOG [Database_name] TO disk=’Path of file’ WITH INIT , NOUNLOAD , NAME = N’Database_name transactionslog backup’, SKIP , STATS = 10, DESCRIPTION = N’Database_name transactionslog backup’, NOFORMAT
visit below links more informations http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_565v.asp http://www.dbazine.com/sql/sql-articles/mullins-sqlserver Deepak Kumar –An eye for an eye and everyone shall be blind
Books online is a best resource to know such basic factors inSQL. 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.
]]>