Viewing 15 posts - 6,256 through 6,270 (of 9,253 total)
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.
November 17, 2011 at 6:04 am
NickBalaam (11/11/2011)
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...
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...
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...
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...
November 15, 2011 at 9:47 pm
No snapmanager, use SQL server log shipping.
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...
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...
November 15, 2011 at 1:32 am
Vladimir
I have not had chance to verify the code yet but the following is bothering me.
The temp table is populated by database users who have SUSER_NAME(SID) is null, this...
November 15, 2011 at 1:06 am
Reboot is a little drastic but if that works for you.
November 14, 2011 at 9:41 am
Dev (11/14/2011)
After all the articles and conversations on this topic and you still have this oh so wrong.
What’s your point? What's wrong in the articles?
The point my friend...
November 14, 2011 at 4:19 am
After all the articles and conversations on this topic and you still have this oh so wrong. MysteryJimbo has covered a lot of the key points. I would suggest you...
November 14, 2011 at 1:43 am
dba_mb (11/13/2011)
November 14, 2011 at 1:25 am
Viewing 15 posts - 6,256 through 6,270 (of 9,253 total)