Viewing 15 posts - 3,991 through 4,005 (of 9,244 total)
Close any connections to the database and then connect and re run the query
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2013 at 10:13 am
matt.gyton (8/6/2013)
Perry Whittle (8/5/2013)
Will the new hardware use the same version of windows as the existing cluster nodes?
There is a chance the new servers will have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2013 at 10:11 am
Will the new hardware use the same version of windows as the existing cluster nodes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 5, 2013 at 10:56 am
Set the database compatibility level back to 90
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 5, 2013 at 10:53 am
database mirroring would be the best solution for you here. Replication is more associated with replicating parts of a database rather than the whole database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2013 at 1:47 am
ananda.murugesan (7/30/2013)
In this situation, what will happend Logshipping in standby database..
still continuous apply the log or wait that query execution completion then next log will be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 1, 2013 at 8:23 am
Unless the disks have been presented as Raw Device Mappings to the VM then no, the VMWare kernel would be controlling access to the flat file virtual disks.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 31, 2013 at 11:57 pm
PearlJammer1 (7/31/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 31, 2013 at 7:33 am
The VMWare virtual disks will sit on a VMWare ESX datastore, this itself may have a RAID array underneath it, but it wont mean a blind thing to you or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 31, 2013 at 6:35 am
Yes, my bad you are quite right shrink is available.
Even so, I'm you can manage to scrape up the extra 80GB or so required to pre create the new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2013 at 6:56 am
When you specify the EMPTYFILE clause to DBCC SHRINKFILE the database engine stops writing new data into the file and all existing data is moved out.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2013 at 6:50 am
be careful about just copying system databases between instances, especially clustered instances. Things like different computernames or collations and SMKs can cause a lot of trouble. Migrate the objects between...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2013 at 6:48 am
The full install media automatically detects your architecture platform and launches the appropriate installer.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2013 at 11:57 pm
Even using a partitioning tool on an online cluster volume, i'm not sure this would be a wise thing to do, i assume this is what you are using.
IMHO,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2013 at 8:29 am
starting SQL Server 2008 there is an option available when using the -m parameter which sets the app name that is allowed to connect in single user mode.
This limits connections...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2013 at 4:41 am
Viewing 15 posts - 3,991 through 4,005 (of 9,244 total)