Viewing 15 posts - 7,261 through 7,275 (of 9,253 total)
Guys
Thank you very much for all your kind replies I'm glad you find it useful
george sibbald (3/1/2011)
March 1, 2011 at 7:44 pm
dibbydibby (3/1/2011)
nice article. one question?in your backup TLog statement did you mean to say....
BACKUP DATABASE AdventureWorks TO DISK = '\\hanode1\backup\AdventureWorks_createnewfile.trn' WITH INIT?
Hi
well spotted, no the backup and the restore...
March 1, 2011 at 2:16 am
Hi
message me your email address and i have a couple of docs you may find useful
😎
February 28, 2011 at 10:50 am
if you restart at the same time nothing as there will be no failover partner available for each instance!
Just out of interest how many nodes are in the cluster?
February 24, 2011 at 5:08 pm
Colin Betteley (2/24/2011)
The login appears on the secondary server as a server login, with red arrow pointing downwards.
that is because the login is created as a disabled login, this is...
February 24, 2011 at 7:27 am
TST1 (2/24/2011)
VM admins have never done this either!
presumably someone has attached the LUNs to the ESX server and assigned them as virtual disks to the VMs!
February 24, 2011 at 5:41 am
Colin Betteley (2/24/2011)
but as the secondary databases will be in recovering mode it is difficult to mirror their logins. Or will that happen as part of the general mirroring?
the recovery...
February 24, 2011 at 5:36 am
no, your SAN LUNs probably have already been attached to the VM's. Skip the iSCSI part of that tutorial and proceed starting from "Adding Windows Server 2008 Application Server Role"
Speak...
February 24, 2011 at 4:52 am
EXEC sp_trace_setstatus @traceid=@traceid_returned_by_creator_script, @status = 0;
EXEC sp_trace_setstatus @traceid=@traceid_returned_by_creator_script, @status = 2;
First one stops the trace
second one closes and removes the definition
😉
gemisigo (2/22/2011)
I've found a mouse in the trap!...
February 24, 2011 at 4:45 am
gemisigo (2/22/2011)
February 22, 2011 at 2:56 pm
Scripting jobs is way too much hassle. In this order
Run server side trace
Identify culprit
Slap heads
😉
February 22, 2011 at 2:30 pm
gemisigo (2/21/2011)
February 22, 2011 at 8:10 am
i would use a csvde query to dump to CSV file and then import this into a sql server table, bit convoluted but in my opinion much better all round
February 20, 2011 at 8:37 am
Leo.Miller (2/14/2011)
Can the file be modified to allow you to see multiple package stores on disk?Cheers
Leo
The following link quotes
Books On Line
February 15, 2011 at 7:17 am
this thread is a year old!!
February 15, 2011 at 6:59 am
Viewing 15 posts - 7,261 through 7,275 (of 9,253 total)