Windows Server 2008 uses a 1MB offset for the partition which is compatible with all of the existing sector/stripe sizes, so you don't have to do anything. Partition/Stripe alignment...

If you only have one disk, I'd say no. Unless you are targeting filegroup backups for recovery purposes, which for 50GB isn't probably likely, or you are trying to...

GRE (5/27/2009)

---

I think there occaions when an deatach/attach is the best option especially when dealing with larger databases and you only have native SQL backup to use...Sometimes you don't have...

turnegw1 (5/27/2009)

---

I have a test database used by some third party software. I have two versions of it that contain vastly different data so that different scenarios can be tested....

Charles Kincaid (5/27/2009)

---

Great article. I was under the impression that ALTER DATABASE MODIFY FILE actually moved the file. You seem to indicate that you have to phyically move...

turnegw1 (5/27/2009)

---

Jonathan,

Would the method described in your article work if, instead of moving files to a different location, I wanted to change the underlying physical files for a given database?...

Query the system DMV's for SQLCLR like this:

select assemblies.name as assembly_name,

object_name(object_id) as object_name,

assembly_class,

assembly_method

from sys.assembly_modules

join sys.assemblies on assembly_modules.assembly_id = assemblies.assembly_id

Brian Munier (5/27/2009)

---

Interesting article, thank you. My question is if detach/attach is going away, and I want to move a database from one server to another server does that...

David Benoit (5/27/2009)

---

Jonathan Kehayias (5/27/2009)

---

Brian Munier (5/27/2009)

---

Interesting article, thank you. My question is if detach/attach is going away, and I want to move a database from one server to...

jboc (5/27/2009)

---

On occasion a log file will fill up to the problem point and we could use detach/attach to delete the old log and start over. Not something that we...

Brian Munier (5/27/2009)

---

Interesting article, thank you. My question is if detach/attach is going away, and I want to move a database from one server to another server does that...

Lasse Schioettz (5/27/2009)

---

Hey Jonathan,

Good article. A couple of minor things to mention, though. To detach the database you use "sp_detach_db" - not "sp_attach_db". It may also be worth noting that...

dmajkic (5/27/2009)

---

If sp_attach_db is to be deprecated, what is "the new" way to just attach a database?

BTW:

Is it possible to add a few xp calls...

Josh Leane (5/26/2009)

---

The only real difference is hardware, the production is on a regular HP proliant server, the dev is on VMWare ESX server, but the OS & SQL is...

SQL 7.... That is gonna be tough to get good help with since it has been out of it service life for a number of years now. SQL...