Viewing 15 posts - 7,156 through 7,170 (of 9,244 total)
Abrar Ahmad_ (4/11/2011)
[font="Verdana"]Some sign of relief @http://scottf.wordpress.com/2007/02/09/sql-server-on-vmware-server/
[/font]
That link covers VMWare Server which although very good is not a patch on it's big brother ESX server. The two are vastly different...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2011 at 11:14 am
kstjacques (4/11/2011)
We have two virtual machines running Windows Server 2008 R2 (each virtual sitting on a separate ESX...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2011 at 11:08 am
annasql (4/10/2011)
If so, what should we do?
Quite often the database properties will be become inaccessible so use the stored procedure
sp_ChangeDBOwner to change the ownership of the database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2011 at 4:52 am
homebrew01 (4/8/2011)
2) Take one-time full backup now to re-establish log chain
no need for a full, a differential will do the trick
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2011 at 6:02 pm
dont forget to enclose database names such as that above with these []
use the QUOTENAME() function
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2011 at 5:56 pm
Take source database offline
copy disk files to target server
re attach at target server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2011 at 5:53 pm
Marios Philippopoulos (4/8/2011)
The logship.exe file, used for transaction-log backups, did not get deployed properly: it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2011 at 3:17 pm
Ysaias Portes-483038 (4/8/2011)
You can add as many nodes as needed when you purchase them. "Up to 16 nodes"
Assuming the OP has installed Enterprise edition or above and not Standard edition
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2011 at 11:44 am
so if i read this correct you're saying that if you check the services list on node ECW10PHYDB001 the services are running but when looking through Failover cluster manager the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2011 at 11:00 am
Ninja's_RGR'us (4/8/2011)
What happens if you have a super fast disk array with 1 bad apple in the bunch?
array performance would be degraded admittedly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2011 at 10:55 am
mohammed moinudheen (4/8/2011)
Eg. if total backup size is 100 GB, and if we create 10 stripes, each...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2011 at 7:27 am
EjSQLme (4/7/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2011 at 1:55 am
Ivan Mohapatra (4/7/2011)
how can we take backup at 2 sparate disk at one time ?
can any one proivde me the code or the process by which it can be ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2011 at 1:15 pm
good call on the service status' Jeffrey
I'm assuming as the OP mentions "Failover cluster manager" that the OS\cluster is Windows 2008
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2011 at 5:35 am
I use a well known 3rd party SQL Server backup product that mirrors backup files to the DR server.
These backups are then automatically restored to the DR SQL Server and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2011 at 5:31 am
Viewing 15 posts - 7,156 through 7,170 (of 9,244 total)