Viewing 15 posts - 7,246 through 7,260 (of 9,244 total)
yes it is. message me an email address and i'll send you my guide
March 6, 2011 at 12:47 pm
Non admin users have permissions on sp_configure to view SQL server configs.
March 5, 2011 at 3:04 am
Suresh B. (3/1/2011)
I don't think SQL Server restarts automatically when tempdb is full.
No, but starving the OS of memory will!
March 5, 2011 at 2:58 am
tuntun.oo (3/3/2011)
It gave me new trick.
After testing with new File Group and File at principal, mirroring works.
But, I cannot create database snapshot at mirror.
Before adding File, the following one...
March 3, 2011 at 3:03 pm
ha\dr that is the technology. You could also log ship with mirroring to create another database instance besides the mirror for reporting if you were really wanted to segregate your...
March 2, 2011 at 1:23 am
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
Viewing 15 posts - 7,246 through 7,260 (of 9,244 total)