Viewing 15 posts - 5,941 through 5,955 (of 9,244 total)
you are trying to start the instance from the system32 directory, you need to change directory to the correct bin location path before issuing the start command!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 4:23 pm
na1774 (2/28/2012)
I am trying to move my DB data files into different drive. I used Alter DB and Modify File Commands. But After I changed the Location of File....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 4:21 pm
YaHozna (2/29/2012)
Quick bit of background would probably help. My company has recently implemented a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 4:08 pm
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
Viewing 15 posts - 5,941 through 5,955 (of 9,244 total)