Dump log file | SQL Server Performance Forums

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 Goiti

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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.