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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2011 at 12:47 pm
Non admin users have permissions on sp_configure to view SQL server configs.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2011 at 3:04 am
Bhuvnesh
32 bit or 64 bit operating system
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2011 at 3:00 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!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2011 at 2:16 am
Hi
message me your email address and i have a couple of docs you may find useful
😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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!...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2011 at 4:45 am
Viewing 15 posts - 7,246 through 7,260 (of 9,244 total)