Viewing 15 posts - 3,991 through 4,005 (of 9,241 total)
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
the install media has install locations for x64, x86 and itanium.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2013 at 4:34 am
sql-lover (7/25/2013)
I want to shrink an existing LUN that holds tempdb and I want to do it on the fly, without taking the SQL failover instance down.
Not going to possible,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 26, 2013 at 6:43 am
balasaukri (7/25/2013)
We were trying to expand SAN disk size more than 2 TB as part our requirment. But it failed due to the limitation, NTFS can support maximum of 2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 26, 2013 at 6:30 am
Viewing 15 posts - 3,991 through 4,005 (of 9,241 total)