Viewing 15 posts - 5,656 through 5,670 (of 9,244 total)
in that case SQL Server will not have any dependency on the disks as it does in a clustered environment.
If SQL Server tries to start and the disks are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2012 at 7:31 am
s1123 (4/19/2012)
i have this one db(principal db) in first server and i want to transfer the users/logins and passwords to another db(miroor db) in second server,
can anyone tel me...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2012 at 7:30 am
Indianrock (4/17/2012)
The Microsoft iSCSI Initiator Service shows no dependencies at allThe sql service shows the sql server agent as dependent on the sql service, nothing more.
is this a sql server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2012 at 6:46 am
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
Viewing 15 posts - 5,656 through 5,670 (of 9,244 total)