SQL 2005 and LDF files. Are the following command acceptable and sufficient?
i inherited sql 2005 server has database sbo-common in full recovery model. sbo-common, d:\sql data\sbo-common.mdf, initial size 596 mb sbo-common_log, d:\sql data\sbo-common_log.ldf, initial size 30000 mb as of now, sbo-common.mdf 609kb sbo-common_log.ldf 29322533kb if schedule following commands every night before tape backup runs: --------------------------------------------------- use [sbo-common] go backup database [sbo-common] disk = 'f:\sql backup\sbo-common.bak' go backup log [sbo-common] disk = 'f:\sql backup\sbo-common_log.bak' go dbcc shrinkfile ('sbo-common_log',emptyfile) go ------------------------------------------------------------------------ would above acceptable , sufficient? want sbo-common_log.bak file shrink. what if did following? ---------------------------------------------------- use [sbo-common] go dbcc shrinkfile ('sbo-common_log',emptyfile) go backup database [sbo-common] disk = 'f:\sql backup\sbo-common.bak' go bac...