Tuesday, 3 September 2013

How to use a shrinkDBs.bat file to truncate all log.ldf files in nested folders?

How to use a shrinkDBs.bat file to truncate all log.ldf files in nested
folders?

References

Reference NO 1

http://stackoverflow.com/questions/15165696/how-to-use-a-shrinkdbs-bat-file-to-truncate-all-log-ldf-files-in-nested-folders

Reference NO 2

http://stackoverflow.com/questions/16387439/how-to-find-the-session-that-owns-a-transaction-blocking-the-truncation-reuse-of

Reference NO 3

http://sqlbits.wordpress.com/

Reference NO 4

http://sqlanddotnetdevelopment.blogspot.com/2011_03_01_archive.html

Reference NO 5

http://www.bigresource.com/MS_SQL-drop-and-recreate-views-in-mssql-server-OrFG2q0i.html

Reference NO 6

http://answers.flyppdevportal.com/categories/sqlserver/sqldatabaseengine.aspx

Reference NO 7

http://technet.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.database.aspx

Reference NO 8

http://www.sqllion.com/2009/05/optimizing-tempdb-in-sql-server-2005/

No comments:

Post a Comment