Viewing 15 posts - 6,331 through 6,345 (of 9,241 total)
dajonx (10/21/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2011 at 8:09 am
Brandie i have seen similar to this before, what is the recovery model of the database, if full do you take transaction log backups of this database?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2011 at 7:15 am
PhilipC (10/23/2011)
I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2011 at 7:09 am
If you're having troubles with other external connections you may use the following to start sql server single user mode and only accept a connection from SQLCMD
sqlservr -c -m "SQLCMD"...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2011 at 4:42 am
database user permissions are held in the database itself. You only need to ensure that the server login SID matches the database user and this si what sp_helprevlogin does
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2011 at 1:33 pm
vino5786 (10/23/2011)
I have configured the Logshipping -Copy Job (Which copies tran logs from Primary Server) to copy all the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2011 at 1:28 pm
Yes you do! 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 6:19 pm
muthukkumaran Kaliyamoorthy (10/21/2011)
No no detach/attach is not good option to move the database from one server to another server. It has lots of disadvantages.
Such as??
You could also take the database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 6:18 pm
As comprehensive as my article is, It takes longer than a couple of days and a forum guide to become proficient with windows clusters 😉
Most of the people on here...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 5:55 pm
open MS iSCSI Initiator and go to targets tab, make sure that all paths are connected. Are you using MPIO for the iSCSI targets?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 11:33 am
the command line parameters are used to start the sqlservr.exe for the particular instance you are fixing
Check services.msc for the location of sqlservr.exe for your chosen instance.
Open a cmd prompt...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 10:46 am
mvillar (10/22/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 10:40 am
winston Smith (10/22/2011)
Apologies for the relative open-endedness of the question, but im in a bit of a jam. Ive been put on an assignment for a client where i potentially...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 10:31 am
remove the BuiltIn admins group or remove its membership from the Sysadmin role in each sql server instance to impede Windows administrators
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 10:23 am
ananda.murugesan (10/22/2011)
Hi,Database user to become Orphaned User by automatically, whenever mirror database to change the Principal database.
Please suggestion me, how to resolve this issues?
Thanks
ananda
you can either script the logins...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 8:12 am
Viewing 15 posts - 6,331 through 6,345 (of 9,241 total)