Viewing 5 posts - 1 through 5 (of 5 total)
The powershell script below will return information on drives and mountpoints regardless of whether they host database files.
It has some minor deficiencies but works OK.
Has a critical threshold [%], below...
July 20, 2015 at 9:41 pm
Can you post your OPENROWSET query so I can see a working example? You can substitute things like 'D:\Folder\Filename.dtsx' for the actual filename.
I use the OPENROWSET to...
July 2, 2015 at 4:16 pm
OK, I've got something that I can work with now.
For anyone facing similar situations, here is a summary:
The main problem was the schema references within the XML.
Adding it to the...
July 1, 2015 at 5:14 pm
as far as DTS/SSIS goes, we use DTSBackup2000. We execute an overnight batch of the command line exe to copy all server-based DTS packages to the DR site.
July 31, 2008 at 6:25 pm
yes DR is an interesting exercise. below are some some points from my own experience.
o management do not understand time constraints for items such as bandwidth limitations, data volumes, restore...
July 30, 2008 at 10:52 pm