Viewing 15 posts - 4,066 through 4,080 (of 9,244 total)
I use a logon trigger for situations similar to this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 14, 2013 at 12:12 am
SQLKnowItAll (6/12/2013)
And what if the reason for this is to upgrade OS
Highly unlikely don't know of many shops that upgrade to datacenter from enterprise
SQLKnowItAll (6/12/2013)
or SQL?
you don't need to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 13, 2013 at 8:02 am
No problem we're all here to help one another
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2013 at 11:04 pm
It's pretty simple, build your new cluster alongside the existing and migrate the objects as required (databases, logins, jobs, linked servers, etc)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2013 at 1:15 am
hydbadrose (6/11/2013)
I have to rebuild the clusters so the plan is i have to move the sql databases to a new temporary server and rebuild these servers...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2013 at 12:34 am
So you've had a failover then, do you want to fail it back?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2013 at 12:25 am
Check the event logs for further info as to why the resource will not come online.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2013 at 1:45 pm
can you provide more detail on your storage subsystem?
I'm guessing the files with slow I\O are not on local disks 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2013 at 11:28 am
You have your topology slightly skewed. The witness does not hold mirrored databases, that's the mirror instance that holds them.
The witness is a third instance that provides quorum in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2013 at 9:30 am
I explain it all in the 2 resources I wrote 😉
You might want to read them.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2013 at 9:14 am
IMHO backup jobs should be running on the mirror, they should at least be intelligent enough to skip databases that are not online.
The mirror may not always be a dedicated...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2013 at 8:49 am
what operating mode are you using for your mirror session?
do you have a witness server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2013 at 6:49 am
why cant you create a windows account and use that?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2013 at 5:06 am
Manie Verster (6/10/2013)
You have chosen to link a rather ancient article that covers SQL Server 7.0, 2000, 2005 which is no longer relevant. Under SQL Server 2000 you had to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2013 at 4:50 am
Jai-SQL DBA (6/11/2013)
Yes its a regular activity to change DMK and password for CertCan you help me with the steps to change the DMK and password for Cert??
As i pointed...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2013 at 4:35 am
Viewing 15 posts - 4,066 through 4,080 (of 9,244 total)