Viewing 6 posts - 166 through 171 (of 171 total)
There is a fix for this Maintenance Plan bug.
http://support.microsoft.com/kb/934459
If you're interested in a script, I have a stored procedure that you can use to check the integrity of all your...
April 10, 2008 at 12:33 pm
Have you considered doing your sql server backups to disk? I think this is better from an reliability and performance point of view. (This means that you would have to...
April 9, 2008 at 2:19 pm
I think that you should avoid shrinking, not only the transaction log, but also the database.
Paul Randal wrote about this in his blog some time ago.
http://www.sqlskills.com/blogs/paul/2007/11/13/AutoshrinkTurnItOFF.aspx
About recovery models and transaction...
April 9, 2008 at 2:07 pm
I have a stored procedure that you can use if you like.
EXECUTE dbo.DatabaseBackup @databases = 'USER_DATABASES', @Directory = 'C:\Backup', @BackupType = 'FULL', @verify = 'Y', @CleanupTime...
April 8, 2008 at 12:22 pm
Could it be anything with antivirus or backup software that is locking the file?
Ola Hallengren
April 8, 2008 at 12:14 pm
In case you would go for the index-level option I have a stored procedure that might be helpful. (It could be that you have to keep the tables online and...
April 2, 2008 at 1:35 pm
Viewing 6 posts - 166 through 171 (of 171 total)