Just take full backups weekly (or daily). Same with model. As Lynn pointed out, you can't take log backups of master and model should almost never change.

Because restore history is the restore from backup history, not reverting to a snapshot.

Is this a production server? If so, why is a dev creating and reverting snapshots?

emily-1119612 (3/1/2010)

---

I have seen code so concise that I couldn't even understand it with my mere-mortal tsql skills. And of course I have seen bloat. For me this seemed to...

Someone's either run Backup Log with truncate only or has switched the DB into simple recovery and back. Those two things will break the log chain.

Both will be logged to...

No one interested in the soccer world cup?

Both will transfer the database users. They're stored in the database, hence they move with the database.

Neither will transfer the login information. That you'll have to script out, preferably with...

Excellent

It was kinda interesting watching the twitter comments, with people rooting for both sides, without actually watching the game.

Who actually won the hockey yesterday?

I went to bed before it was finished and didn't feel like wading through hundreds of twitter updates this morning.

SELECT <column list> FROM fn_dblog(null,...

No services need to be stopped to detach and attach a database. Just note that the DB will be unavailable while the copy is in process.

Backup/restore is a better option,...

If you want to track transactions and changes, you're better off using triggers or a SQL trace. The transaction log was never intended to be human readable, if you want...

Does master change so often that you need it in full recovery and log backups being taken? Same goes for model?

There are some fundamental differences between a primary key and a unique constraint, not...

RalphWilson (3/1/2010)

---

IMHO, if you must use a GUID for your Identity column (and I will concede that there are times when that is the proper choice 😉 ) then you...

Have a look at Andrew Kelly's stuff. His blog is here: http://sqlblog.com/blogs/andrew_kelly/, I think he's written stuff for SQL Mag and other places.