pausing not strictly necessary but yes those are the steps. Take a log backup just before you start.

The log of the primary will fill whilst the secondary is down so...

alanspeckman (10/4/2013)

---

I have a mirrored setup, my principal server becomes unresponsive and the witness and mirror decide to failover to the mirror, so now roles change and the mirror is...

I don't need it broken down and if you check back I am not the OP in this thread, so I don't have a problem I need advice on.

I seem...

is the log backup job running successfully?

it suggests your log backup job is failing. Have you done an initial full backup? Is the database still in full or bulk logged recovery mode?

Hi, what do you mean by mapping? Yes that script will tie the logins to the users in the databases because it brings the sids over, i.e. they are mapped...

It's the Database!!! (10/8/2013)

---

PearlJammer1 (10/7/2013)

---

Are you sure that it also mapped the users database access and permissions ? When i run the...

that script only gives the logins, sids and passwords, plus default database.

The user permissions would only come across if you copied the databases over. As you are not you need...

well if it does not I guess that is a good thing. 🙂

All I can think of is to run dbcc proccache immediately before and after or run profiler with...

did you get the message 'SQL Server has encountered %d occurrence(s) of cachestore flush for the '%s' cachestore (part of plan cache) due to some database maintenance or reconfigure operations"....

are you transferring the databases as well, because this should retain the login\user mappings. Please describe your full process.

don't shrink it, it will just grow again on the next reindex. Either back the log up more frequently, put the database in bulk logged mode during the reindex or...

I am no VMware expert and may have the terminology wrong but you can definitely vmotion(?) or bring up a virtual server in another location with the same ip address,...

Also run these

alter database dbname set page_verify checksum -- torn_page_detection

-- upgrade creates a schema for all users and sets this as default, use following to create SQL to

-- modify users...

It's the Database!!! (9/26/2013)

---

so restore in no recov, add my diff in no recov, then add manual logs in no recov, then start log shipping with secondary alreay initl in...