Planning to Shrink Transaction Log ..

[funcrecall12]

Hello ..
Im planning to Shrink my transaction Log.
The server to use is SQL 7.0. and I already
have full backup of the file/Database both Flat file
and using the backup utility of SQL 7.0.
Im not sure what to use in shinking the File/Transaction Log

1.

DBCC SHRINKDATABASE (DataDB, 10)
GO

2.
USE UserDB
GO
DBCC SHRINKFILE (DataFil1, 7)
GO

Please Advice

 

[MeanGreen]

I would use the DBCC Shrinkfile. It works best when dealing with the transaction log.

Hope this helps.

 

[tlbroadbent]

Review faq183-1534 - Shrinking Databases and Logs - SQL 7 and Higher.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[funcrecall12]

Great!! Men Look I have the best answer now ...
I have the 2 Best/TopNotch Tipster in the Forum ..

Thank you very much ..