Sure, attach/detach a database is the quickest way of disconnecting it, copying underlying files and reconnecting (attaching) on another server. It is very useful especially for very large DB when a backup/restore may take hours or days. A good thing could be also to zip files before moving them if they are very large.
2003-07-24
This might not be the best place to post this because it is getting too asp instead of SQL but its worth a try 🙂 When accessing data from a data base I try to test whether a value is less than another to move on to a further step. I have a value license, […]
2003-07-20
1 reads
2003-07-15
1 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers