Thank this author by sharing:
By stalley-gordon, 2013/05/25
This can be run as a job or manually. There are no parameters so it will do ALL log files that it finds; excluding system files.
If you want to shrink all database files including data files (and indexes) then find these lines of code:
SELECT @exec_stmt = 'INSERT INTO #logfiles SELECT ''' + @DBName + ''' , name FROM ' + quotename(@DBName, N'[') + N'.dbo.sysfiles WHERE groupid = 0'and replace it with this code:
SELECT @exec_stmt = 'INSERT INTO #logfiles SELECT ''' + @DBName + ''' , name FROM ' + quotename(@DBName, N'[') +N'.dbo.sysfiles'
query(dbname,size,recoverymodel)
Concatentaion of @dbname from cursor + table name to use in FROM clause
Alter Database DBNAME Set Recovery Full. Gives error.
query to get dbname,totalsize,reservedsize of all databases in sql 2000
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
