http://www.sqlservercentral.com/columnists/SBoriotti/exchangefromsqlserver.asp

Not quite what you want, but they have a product to help with that.

getdate() will get you the exact minute. If you need everything from today, you'd need to calculate the current day minus the time,

select datepart(mm,getdate() + '/' + datepart(d, getdate())...

MS_foreachtable will run a command against all tables. Might be a way to script it for all indexes.

b&r - your SLA will depend on the tape SLA to get data from tape. I'd set this at some xx minutes per GB. Test in your environment.

User Access -...

Couple things.

Rename - be sure you rename the SQL Server as well as the computer.

The copy objects wizard has been flaky for me (and the task). I'd back and restore...

Scan for all servers.

Check versions/patches

Check security config

Check service accounts

Check for pwds on all accounts

Check for use of roles

Check who has any fixed roles

Be sure you check this againts software that they are using. It's possible there are reasons for downlevels. Not that they shouldn't be patched, but be sure that you know...

I'd agree about using roles. This is exactly why you do it. Take a few minutes and move the permissions to a role and then ad your new user.

You can use this to try and shrink the log

http://www.sqlservercentral.com/scripts/contributions/26.asp

You can move these selects to the FROM clause.

select a, b, c, d

from main, (select c, d, from mytable) b

It seems the IE pastes them in as highlights, but Firefox does not. I'll see if we can do something in the forum code for this.

Yes, sigs need to be manually done, but this is a cut and paste:

http://www.sqlservercentral.com/columnists/sjones/

Haven't seen this. Course, I haven't restored a v7 db in quite some time.

Are you restoring through the GUI or with T-sQL? I might try TSQL to see if any...

Wow, offhand, I'm not sure what to do here. Since some items are not in ", I'm not sure the above will work.

I think I'd write some VBScript or small...

Or "fix" the existing user in the prod database with the test login by using SP_CHANGE_USERS_LOGIN.