Comments for SQL Philosopher » SQL Philosopherhttp://www.sqlphilosopher.com/wp
Brad Hoff's Notes about SQLFri, 19 Jul 2013 20:10:54 +0000hourly1http://wordpress.org/?v=4.1Comment on Moving a Filegroup to a New Disk Array with No Downtime by SQLPhilosopherhttp://www.sqlphilosopher.com/wp/2012/02/moving-a-filegroup-to-a-new-disk-array-with-no-downtime/#comment-985
Fri, 19 Jul 2013 20:10:54 +0000http://www.sqlphilosopher.com/wp/?p=28#comment-985I’m glad to hear that it helped you out! And yes, good point about the log space.
]]>Comment on Moving a Filegroup to a New Disk Array with No Downtime by Szymonhttp://www.sqlphilosopher.com/wp/2012/02/moving-a-filegroup-to-a-new-disk-array-with-no-downtime/#comment-983
Thu, 11 Jul 2013 16:42:39 +0000http://www.sqlphilosopher.com/wp/?p=28#comment-983Thanks for the tip, it saved me a lot of time. The only thing to remember is to have enough space for log growth.
]]>Comment on Moving a Filegroup to a New Disk Array with No Downtime by A Guide to Database Migrations | SQL Bad Boy – Michael Loweryhttp://www.sqlphilosopher.com/wp/2012/02/moving-a-filegroup-to-a-new-disk-array-with-no-downtime/#comment-970
Thu, 27 Jun 2013 13:59:30 +0000http://www.sqlphilosopher.com/wp/?p=28#comment-970[…] migration (http://www.sqlphilosopher.com/wp/2012/02/moving-a-filegroup-to-a-new-disk-array-with-no-downtime/) – This option can be used when migrating to a new drive with no downtime. The basic idea is […]
]]>Comment on My Red-Gate Hyperbac + DBCC CheckDB Script by SQLPhilosopherhttp://www.sqlphilosopher.com/wp/2013/01/my-red-gate-hyperbac-dbcc-checkdb-script/#comment-417
Thu, 07 Mar 2013 21:51:27 +0000http://www.sqlphilosopher.com/wp/?p=83#comment-417I am so glad to hear that it is helping you out. Thank you for following up. It can be a real pain to keep all of the pieces straight, but it sure is a great peace of mind when you know that your backups are working and that you are keeping an eye on corruption.
]]>Comment on My Red-Gate Hyperbac + DBCC CheckDB Script by Ed Watsonhttp://www.sqlphilosopher.com/wp/2013/01/my-red-gate-hyperbac-dbcc-checkdb-script/#comment-416
Thu, 07 Mar 2013 21:47:15 +0000http://www.sqlphilosopher.com/wp/?p=83#comment-416I knew there had to be a good reason, I just added the logic to my copy. We had such a hard time trying to get this to work (before your script) with the Virtual Restore after scripting it to work with the Backup Pro. I just kept screwing it up for some reason. Thanks for sharing it.
]]>Comment on My Red-Gate Hyperbac + DBCC CheckDB Script by SQLPhilosopherhttp://www.sqlphilosopher.com/wp/2013/01/my-red-gate-hyperbac-dbcc-checkdb-script/#comment-415
Thu, 07 Mar 2013 21:43:32 +0000http://www.sqlphilosopher.com/wp/?p=83#comment-415Ed, this is a great question. Within my environment, I maintain a table with files that need to be cleaned-up. When a restore and consistency check completes, I add the associated backup files to that table, after dropping the virtual database, of course. I then have a process that cleans up those files in the background.

I do it this way for two reasons. 1, if a deletion of a file fails and needs to be retried, I want to handle that all in one place, rather than implement that logic in multiple different scripts throughout my environment. 2, if a restore or consistency check fails, I want to already have the exact copy of the backups that were used right there on disk. This aides in my troubleshooting.

In the script I published online, I left out this logic for simplicity. I can also imagine that some people may prefer that I not delete those files automatically, due to some perceived risk.

I hope that makes sense. If you, or someone else, would like some help with the deletion logic, I would be happy to discuss and help as best as I can.

]]>Comment on My Red-Gate Hyperbac + DBCC CheckDB Script by Ed Watsonhttp://www.sqlphilosopher.com/wp/2013/01/my-red-gate-hyperbac-dbcc-checkdb-script/#comment-414
Thu, 07 Mar 2013 21:26:16 +0000http://www.sqlphilosopher.com/wp/?p=83#comment-414It seems to work pretty good after a couple of days. I am curious why you do not delete the backup copies?
]]>Comment on My Red-Gate Hyperbac + DBCC CheckDB Script by SQLPhilosopherhttp://www.sqlphilosopher.com/wp/2013/01/my-red-gate-hyperbac-dbcc-checkdb-script/#comment-413
Tue, 05 Mar 2013 21:46:44 +0000http://www.sqlphilosopher.com/wp/?p=83#comment-413Thanks, I may have missed that when I was cleaning it up for publishing it to the site. I do insert a value into that table within my environment. I must have just missed it when I was removing the artifacts from my environment. I will take a deeper look when I get home. Thank you for bringing it to my attention.
]]>Comment on My Red-Gate Hyperbac + DBCC CheckDB Script by Ed Watsonhttp://www.sqlphilosopher.com/wp/2013/01/my-red-gate-hyperbac-dbcc-checkdb-script/#comment-411
Tue, 05 Mar 2013 21:21:53 +0000http://www.sqlphilosopher.com/wp/?p=83#comment-411What is the purpose of [#checkDBResults].[insert_date]? It fails because you have it as NOT NULL and then never insert anything into it. Other than that everything worked great.
]]>Comment on SQL CLR: An Introduction by Deployment and Usage of a CLR Stored Procedure | SQL Philosopherhttp://www.sqlphilosopher.com/wp/2013/03/sql-clr-an-introduction/#comment-409
Tue, 05 Mar 2013 04:03:35 +0000http://www.sqlphilosopher.com/wp/?p=90#comment-409[…] post is part of a series of blog posts entitled SQL CLR: An Introduction, the other posts are as […]
]]>