I'm not a big fan of using the current user in that way, I prefer to use an AD group thats specifically created for whoever is gonig to be SYSADMIN's,...

This may help you out:

https://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/

The FAQ area of Ola Hallengren's site has some good tips http://ola.hallengren.com/frequently-asked-questions.html. While your at it consider using the full maintenace solution, at least get a copy and play...

You can do this a lot cleaner using nested AD groups, use a Local Group for allocating the SQL Level Permissions then make global groups or universal groups members of...

reminds me of a session at this years SQLBits 🙂

Nice artical, I must admit i'm still a fan of detatching the databases to move files as I tend to only do this on maintenance windows so the amount of...

At what point am I criticizing sp_blitz? i'm trying to share my experience with using SA as the database owner as per the comment above.

I agree with you...

*prepairing to be shot down

I've never had any problems setting SA as the DB owner with the SA account disabled, its a practice I follow even when the instance is...

Great introduction to this valuable tool

Good point Grant, how much detail do you want i'm happy to do a full blow by blow review it will just take me a few days as the day...

SQLDBA360 (9/26/2012)

---

Scary's artical is a good http://www.simple-talk.com/sql/database-administration/sql-server-backup-and-restore-for-the-accidental-dba/%5B/quote%5D

oops haven't been on for a while http://www.simple-talk.com/sql/database-administration/sql-server-backup-and-restore-for-the-accidental-dba/

Scary's artical is a good for backups http://www.simple-talk.com/sql/database-administration/sql-server-backup-and-restore-for-the-accidental-dba/

Steve Jones - SSC Editor (9/21/2012)

---

The question was poorly worded and I missed the total disk activity in edit.

The question has been corrected and points awarded back as of a...

This highlights something I heard in a presentation that Whitepapers and Best Practices can be dangerous things 🙂

Is there any reason why the prod and UAT boxes can't be in a single domain or at least the same forrest, what you are trying to do is much...