Viewing 15 posts - 5,941 through 5,955 (of 9,241 total)
cphite (2/27/2012)
As it stands right now, we're going to leave MAXDOP at 1
you've just slapped the hand cuffs on every query executing on the server!
As Gail said, find out why...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 4:05 pm
full machine backup and subsequent restore to the physical box would be my chosen avenue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 3:58 pm
dunne.neal (2/28/2012)
I am having problems connecting to a local instance of sqlexpress.
ive tried (local)\sqlexpress but i get the error saying that the server cant be found
i click on browse...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 3:55 pm
does the computer account for server A definitely have delegation enabled
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 3:53 pm
gmamata7 (2/29/2012)
Is this native SQL Server backup, or a third party backup?
Is it local, or to a remote drive or share?
It is sql native backup.
Backups to a clustered drive.
edit...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 3:18 pm
Steve Jones - SSC Editor (2/25/2012)
You'd have to change the server names, but that's not a big deal.
Not if they're in an environment that is segregated from the public network,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2012 at 5:01 pm
are the disk\file paths different between the 2 servers?
are you cloning for testing purposes, if so have you thought of cloning the whole server to a virtual machine?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2012 at 4:03 pm
saidapurs (2/21/2012)
I got the solution after seeing error log in Witness server.....
Error :-
Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed with error:...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2012 at 9:16 am
hmm, not sure I'd use the index physical stats dmv to get table usages, this should work though
selectobject_name(p.object_id) as TableName
, p.rows
, a.total_pages * 8 as TotalKB
, a.used_pages * 8 as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2012 at 5:16 pm
could you explain why you have set this
SQLRO (2/23/2012)
ROWTERMINATOR = '',
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2012 at 12:44 am
dbrackin (2/22/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2012 at 12:30 am
How many log shipped databases ate we talikng about total?
It sounds like your main aim is to provide availability?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2012 at 12:27 am
What share\NTFS permissions are set for Certstore?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2012 at 12:17 am
When you launch the sql server installer exactly which option are you selecting?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2012 at 12:14 am
Are you trying to use the same group for the new instance on node b that is already in use for the instance on node a
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 23, 2012 at 12:09 am
Viewing 15 posts - 5,941 through 5,955 (of 9,241 total)