When working with SQL Server, the OS will commonly be (in the enterprise environment) Windows 2000, Windows NT 4.0 SP6, Windows Server 2003* or 2008* (*NOT RECOMMENDED!).
Sometimes, databases are large and we need a copy of reporting for row-locking/hacking. Backing up, copying and restoring is not a viable option when we hit a certain size, so we'll employ a method of "cloning". And no, not like Arnold Schwarzenegger on "The 6th Day", we're talking copying storage devices.
First things first, you'll need a Windows Resource. When reaching out for a "Windows Resource", just call Farooq. Although Farooq is a DBA, you should call and wake him up. Even if you have two other production DBA's on the call, and you need a Server Systems resource, just call Farooq. He will bring you donuts.
###UPDATE###
Be SURE to run CHKDSK. Ensure that it reboots the box randomly... This will bring all databases online. Or offline. Not sure...
Next step is to use ancient batch files (.bat) from the DOS world to disconnect, fracture, copy and re-connect those drives. Once Complete, you can now lock all the rows you want !
No comments:
Post a Comment