Get database name:
SELECT * FROM master.dbo.sysdatabases
Get File group ID
Use [db_name]
select * from dbo.sysfiles
Truncate and shrink Transaction file:
Use [db_name]
BACKUP LOG [db_name] WITH TRUNCATE_ONLY
DBCC SHRINKFILE (fileID)
Showing posts with label truncate transaction log. Show all posts
Showing posts with label truncate transaction log. Show all posts
Monday, January 5, 2009
Subscribe to:
Posts (Atom)