Viewing 15 posts - 6,241 through 6,255 (of 9,241 total)
Check out my highly acclaimed 3 part guide for creating a virtual SQL server cluster on this site. It educates the DBA in server, clustering, AD, networking and storage technologies....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2011 at 1:09 pm
alban_ml (11/18/2011)
how to chek the error state ?
It's in the SQL server log 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2011 at 12:13 pm
Most of the organisations I have worked in previously have virtualised SQL servers. Obviously not all SQL Servers are ideal virtualisation candidates, this requires some due diligence.
In my opinion virtualisation...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2011 at 11:07 am
Try adding the node using the setup command line install.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2011 at 10:42 am
The other option which may be easier for you is to run sp_change_users_login with 'Auto_Fix' and create a matching login for each orphaned database user using a default password. After...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2011 at 10:38 am
Ok, but DR typically does not encompass your whole estate, it's meant as temporary failover with core services\applications exposed.
Do you really need to LS everything??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2011 at 7:26 am
See the following link for details of how to implement log shipping via T-SQL, it details all the stored procedures you will need to execute.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2011 at 6:04 am
NickBalaam (11/11/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2011 at 2:44 am
Dude Oracle_91
Restore the master backup as a user database, call it oldlogins.
Once database oldlogins has been restored script out username, SID and hashed password for each user in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2011 at 2:31 am
Ensure your certificate is for the computers FQDN and not just the computername. I.e. myserver.somedomain.com and not myserver
Ensure you have imported the certificate correctly.
Ensure you have bound the certificate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2011 at 2:23 am
Ensure your certificate is for the computers FQDN and not just the computername. I.e. myserver.somedomain.com and not myserver
Ensure you have imported the certificate correctly.
Ensure you have bound the certificate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2011 at 2:21 am
winston Smith (11/15/2011)
How do i restore that database backup onto serverB?
You don't need the service master key, A backup of the certificate and its private key are all you need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2011 at 9:47 pm
No snapmanager, use SQL server log shipping.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2011 at 8:05 pm
Vladimir Mednikov-324895 (11/15/2011)
You can script missing logins and user roles on the source server and recreate them on the target server before fixing orphan users.
Database roles are transferred with the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2011 at 7:38 pm
chandan_kumar_sahu-987370 (11/8/2011)
I am a database developer and expected to a DBA activity for High availability concept.
We have a requirement to set up windows2008 R2 server Cluster environment with SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2011 at 1:32 am
Viewing 15 posts - 6,241 through 6,255 (of 9,241 total)