sql server 2008

[AndyInUK]

Hi, i want to copy the database from one system to pen drive and then add that database to another system. How can i achieve this ? Thank you

[sarang_k]

right click on database->tasks->restore->database. you wil get a window select the radio button From device and then click on .. you wil get another window then click on add and choose your database from the pen drive.

[AndyInUK]

sarang_k wrote:

you wil get another window then click on add and choose your database from the pen drive.

No it doesn't let me store in pen drive. what is backup option under task if restore does this job as you said ??

[Abhishek Sur]

Yes.. Removable devices will not be listed in Backup folder browser. So backup in anyfolder and then copy it to your pen drive. Backup option means you make a compressed file that could produce the exact same database instance. If you have a backup file you can restore it to any sql server instance easily. Are you clear now ? :)

Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.

---

My Latest Articles-->** Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

[Mycroft Holmes]

As sarang said, you can also create a new database on your target system from a backup, IE restore to an new database

Never underestimate the power of human stupidity RAH

[Lost User]

1. Right click the source database, select Tasks --> Backup. 2. Specify a backup location on your hard disk. 3. After the backup process is complete, copy the backup file to your pen drive. 4. On the destination server, copy the backup file to your server's hard disk. 5. From SSMS, right click 'Databases' folder and select Tasks --> Restore. Follow the instructions from there.