you will be fine if you if you:

run sp_help_revlogin against primary server and save output to file

copy file to secondary and load into SSMS query window

edit to remove those logins...

or else. drop the logins and use sp_help_revlogin to copy them over again.

OR

when you failover properly for the first time use stored procedure sp_change_users_login to tie the user in the...

Unless you index the view it is not a 'physical' object, so the lock would be held on the table.

Unfortunately there can be many causes for this error, its one of those that makes ny heart sink when I see it. What I would say is approach this from...

how were they copied over? what is the exact error in the errorlog (need the state value in particular from the login failure)

the sync with backup option is used in replication to ensure you have a consistent recovery point with the distribution database if you have to restore the publication database. It...

what happens when you want to patch the cluster?

tell the sysadmin you gotta do the change out of hours at 3a.m.,see if he wants to get up to offline the...

Are you also copying over the logins? google sp_help_revlogin to see the process for doing this.

SQL Noob (11/19/2009)

---

you can restore 32 bit databases to 64 bit servers. every day we have a process to copy data on our SAN to volumes that are used by...

then there is the question of can you restore 32bit system database to 64 bit, that I am not 100% suer about................

OS changing to 64 bit or is OS and SQL?

you should get away with that as long as you install SQL EXACTLY as on the old server, version, service accounts,...

so you've tried breaking up the reindex job into chunks, increasing the frequency of the log backups, reorganise instead of reindex?

This is a classic issue with logshipping. I presume logshipping breaks because of the size of tranlog backup produced after reindexing?

To avoid going over old ground see this thread

http://www.sqlservercentral.com/Forums/Topic817469-357-1.aspx

SQL Noob (11/18/2009)

---

i run SQL 2008 management tools on my PC's and 2005 in production. the client tools work great and offer more functionality than the 2005 Management studio. only...

requiring RS for SUA seems a right royal pain. You have to ask yourself why.

could 2008 clients have been rolled out before the server upgrades? Does 2008 client tools support...