Moving DB Files

I did this one last week and just forgot to blog it.

This one's on moving user DB files, though the process works just fine with tempdb and msdb.

Now, there at the end when I take the DB offline using code and then online using the GUI, I just brainfarted, so I don't wanna get any email telling me that I can bring a

DB back online with this:

ALTER DATABASE DBName

SET online

I'm well aware.

Trace Flag 1807

OK, I just posted a new vid on trace flag 1807.

It's good stuff if you ever needed to create or attach a DB with files across the LAN.

Check it out here.

Protected: How to lose your MVP (in one easy step!)

This content is password protected. To view it please enter your password below:

Real news, real tech.