Thanks for the replies.

Brian, can you expand on that, do you mean they could run sp_delete_job? BOL does not seem to suggest that.

Elliot, this is a dev environment and the...

you need an account with sysdmin to connect, then configure the security (using the roles in RS) via the URL http:\servername\reportserver

2008 and 2008R2 are different versions and therefore on different 'tracks'. so the SP2 for 2008 is not applicable to R2.

I would agree that if you are upgrading at this...

our posts crossed pam, that was not explicit from your first post 🙂

alter database modify file is still the better way to move database files, which means offlining the database.

if its in single user mode how do you know you will be the fist user to connect to the database?

rather than detach\attach use alter database modify file command. It...

maybe you just have not transferred the logins?

If you have but created them on the secondary server the user and login now have different sids and the user is orphaned...

you need to run dbcc shrinkfile. Try the truncateonly option first. If that gives you no space back specify a size less than 10GB but with which gives you reasonable...

are you running transaction log backups?

you can convert clustering from an HA solution to a true DR set up by:

setting it up as a geo-cluster (SAN replication and windows 2008 required)

log shipping to a third...

SQLAgent?

you will have to write your own custom process but you can log ship to a higher version, You will have to leave the database in norecovery mode, the standby...

you really should read this:

http://sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx

its asking for your windows account and password

creating\dropping objects will be in the default trace.

some server configuration changes will be in the errorlog but not exactly sure which will or won't be.

If this is SQL2008 you could...

Are you scripting out jobs created by maintenance plans?

I have come across an issue in 2008R2 RTM where if two jobs have steps with the same name it confuses the...