Viewing 15 posts - 5,656 through 5,670 (of 9,241 total)
anthony.green (4/19/2012)
Think its the -m or -c switch you want
It's both 😉
-m starts the instance single user and -c shortens the command prompt startup time as it bypasses the calls...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2012 at 6:36 am
opc.three (4/18/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 11:56 pm
i would always prefer the same versions but when it comes to editions, if all my witness was going to was act as a witness i'd use express edition 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 2:21 pm
had something similar to this on an exchange server some years ago, repeated corruption turned out to be a whacko RAID backplane\bios. check and double check all areas of the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 2:15 pm
if an application is not working as expected its known as "faulting". An object that is faulty is not working as designed\expected 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 1:25 pm
GilaMonster (4/18/2012)
Database mirroring is a DR technology that can also be used for reporting
Assuming your installed SQL version on the secondary instance allows snapshots of the mirror. Even then these...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 1:03 pm
jonathanalvestad (4/18/2012)
I'm in a student group working on a project, our project needs a website with possibilities to make orders...so...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 10:41 am
already answered at this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 9:53 am
if you go into the new help dialog and click updates you will be presented with a list of help topics to download including BOL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 9:51 am
karthik.catchme (4/16/2012)
What is the difference between Availability Group and Replica? I understand that availability group is a container for set of databases.
But, can someone please let me know...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 9:49 am
if you don't have a shared volume it won't use one but will warn that the current configuration is not suitable for the number of nodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 9:40 am
you need to restore the full backup using either
WITH NORECOVERY
or
WITH STANDBY = drive:\path\standby_file_name
you may then initiate log shipping. Alternatively let the Log Shippiong setup process do this for you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 6:44 am
sc_2111 (4/18/2012)
if I take down the MIRRORED DATABASE on the principal the target should become active automatically.
Loss of the Principal will indeed bring the mirror online, again, check Automatic Failover...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 6:39 am
dsohal (4/18/2012)
I restored for .bak file and then ran the query to make the database as read only, I am not sure how to make it standby/read
so, you restored the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 6:33 am
have you checked the Windows application and system logs?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 5:56 am
Viewing 15 posts - 5,656 through 5,670 (of 9,241 total)