I'm one of 3 DBA's here ( in a total group of 40 operational guys (networking , exchange, hardware , OS related etc etc ( we are doing the whole of Europe from here ))) and I'm busy cleaning up the mess other (once) made.......I also have no time to play out on the street...Guus
2004-11-11
Gary,For log shipping, the secondary server should be in read-only mode. There is nothing wrong with it. With you having mentioned that all the copy and restore jobs are successfully, i can't think of anything else. Can you verify that the loginhistory table is in the log shipped database ?
2004-09-22
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-09-13
Here are some pointers you can use:MovingDB's between Servers : http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546 Q246133 INF: How To Transfer Logins and Passwords Between SQL Servers Q298897 Mapping Logins & SIDs after a Restore Q168001 PRB: User Logon and/or Permission Errors After Restoring Dump Q240872 How to Resolve Permission Issues When a Database Is Moved Between SQL Servers Q224071 […]
2004-09-06
Ok.....You are learning a bit more about SQL Server Replication! In future you should study up on it before installing, configuring and removing SQL Server Replication as it is a huge topic!Now......Those connections you are seeing are Replication Jobs! If you go to your Jobs Folder you will probably see 2 Jobs that were a […]
2004-02-10
1 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers