Out of interest why are you renaming the server as you have no SSIS packages which are most affected by server name?

with the logins have you captured default database, language...

Sorry, reporting services encryption key, backed up via RS configuration manager (or it was in SQL 2005). You will need that if you are restoring the reporting databases to another...

any user code in system databases (naughty)?

any user defined error messages? (held in master)

backed up and copied over your RS Key if you are copying RS databases over.

Thanks Steve. Anyone else so we have a quorum?

RBarryYoung (4/14/2010)

---

SSC has started subtracting points for bad...

Try issuing a DENY CONNECT SQL to the individual accounts, see if it works.

posts crossed [-] see above

place [] around the server name.

Avoid names like this in the first place 🙂

there sound like a lot of potential gotchas in there. Don't start unless you are sure they are all ironed out.

First question is is there an upgrade path from windows...

I would go with log shipping as the best replication method to achieve that, as long as you don't need to update in the development environment.

mirroring with snapshots is another...

To change the time-out value (high-safety mode only)

Use the ALTER DATABASE <database> SET PARTNER TIMEOUT <integer> statement.

To view the current time-out value

Query mirroring_connection_timeout in sys.database_mirroring.

darn it, only gone...

Another thought, on the secondary transaction log backups are deleted by age from the datestamp of the file just restored, so set deletion variable to same as frequency of...

Elliott W (4/14/2010)

---

I was looking at this in SQL 2008 and it does give you the options. Not sure if there is a difference. I haven't set up...

there is nothing in the logshipping process as supplied by the GUI to do it, you would have to write your own.

I suggest make it a process that is kicked...