i have two different hard disk drives, here i call it HDD1 and HDD2. i want to format my HDD1, but all my database tables are stored in HDD1. i want to know is there any way for me to backup my database table to HDD2, and restore it back later to HDD1.
thanks to you all.You can either do a back up and restore or detach the database files, move them, and then re-attach them. There's on option when restoring backups to move the data files. Detaching the database basically closes the files and removes them from the SQL server. Re-attaching them brings them back to 'life'. Either would work. Check BOL|||I already used the wizard in sql server to backup my file, the back-up file ends with .bak extension, right? But the problem is i don't know how to restore it back. I have tried using "Restore" function from sql server, but it does not work.|||The .bak file is the correct file. Dig into books on line about restoring from a file. Pretty hard to diagnose via email, but unless your SQL installation is somehow corrupted, it should be able to restore a backup file.
