I just wanted confirmation that a Rollback would occur on the failed Alter Database Rebuild command I presented, in Bulk-Logged model. If the rollback fails for whatever reason, then a...

Thanks. This is what my testing showed, just wanted to make double sure about the roll back. Data loss in not acceptable...

Good morning all. I have a question. If I run an Alter Index Command as follows with the database in Bulk-logged model and the Alter Index fails, will...

Good morning Michael,

I've been on Vacation.

Your solution is very interesting! Never thought of using

RunCmd """for /f ""tokens=* delims=s"" %f in ('dir /ad " & driveLetr...

Eric,

I agree that xp_cmdshell has security risks and I should have acknowledged this in this article. Thanks for bringing up this point so everyone has a clear understanding of...

Thanks. We will look at adding this because CDROM Drives do not interest us at all 🙂

Great! Glad the script is running on your 64 bit system.

Can you share the code that handles CDROM??:)

Sorry to say we have no 64 bit servers yet, so I have not run into this issue. I did a web search on 'running vbs scripts on 64...

As we understand, 'xp_fixeddrives' was really an unofficial xp and we were unsure how long it would be available. So, when we changed the original procedure for SQL...

Well thanks for the info. I wanted input from other DBA's.

We have the ability to increase the size of existing Drives (SAN LUNs) along with adding new Drives....

We just need to expand this database as it is growing.

All of the existing SAN LUNs are RAID1.

We plan to allocate two new drives, about @108 GBs each.

We will the create 2 new datafiles of 100 GBs and place 1

new datafile on each of the 2...

Our HBA', switches and SAN are not overutilized and not limiting factors. We will continue with our original plan and add 2 new drives. Thanks to everyone...

Thanks alot for the info. I really hate surprises 🙂

Hello Henrik,

Sorry for the slow response, been on vacation since  7/2/05.

Whenever we get negative numbers for free_DB_Space there has been a problem with sysindexes.  Try running DBCC UPDATEUSAGE (dbname) and...