Viewing 15 posts - 1 through 15 (of 17 total)
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...
March 8, 2012 at 10:36 am
Thanks. This is what my testing showed, just wanted to make double sure about the roll back. Data loss in not acceptable...
March 8, 2012 at 7:09 am
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...
March 8, 2012 at 6:43 am
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...
May 30, 2008 at 9:14 am
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...
February 22, 2008 at 7:02 am
Thanks. We will look at adding this because CDROM Drives do not interest us at all 🙂
February 21, 2008 at 12:04 pm
Great! Glad the script is running on your 64 bit system.
Can you share the code that handles CDROM??:)
February 21, 2008 at 11:02 am
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...
February 21, 2008 at 10:18 am
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...
February 21, 2008 at 8:59 am
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....
January 28, 2008 at 5:44 am
We just need to expand this database as it is growing.
All of the existing SAN LUNs are RAID1.
January 24, 2008 at 12:16 pm
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...
January 24, 2008 at 10:06 am
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...
January 24, 2008 at 6:07 am
Thanks alot for the info. I really hate surprises 🙂
October 9, 2007 at 5:15 am
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...
July 21, 2005 at 8:56 am