QUESTION POSED ON: 09 November 2005 I have installed SQL Server on Windows 2003 and made incorrect drive letter assignments to C: with respect to the data files and transactions. How can I undo this error without having to rebuild the entire database?
>
There are a couple ways to do this. The best way is to use the sp_detach_db and sp_attach_db system stored procedures. In essence, you simply disconnect the database from SQL Server, then reconnect it to the server with a new path and file.
Do you have comments on this Ask the Expert Q&A? Let us know.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.
