Tag Info

New answers tagged


It's the identifier for an 8k page in the database. "On disk" or "in memory" is somewhat irrelevant because the answer can be "yes" to both simultaneously. You can look at the contents of the page with dbcc page(8, 1, 401831). dbcc page is undocumented, but you can find plenty of information about it and how to interpret the output out there. NB: by default, ...


In my experience, detach/attach is the fastest method. The bottleneck would probably be how quickly you could copy the files across the network. Assuming the two databases have identical Windows accounts (if you're using SQL accounts you may have to update SIDs), you could probably use something like this script that I have laying around from before I ...

Top 50 recent answers are included