One of my computer have sql installed in it, My problem is that i want those database on other computer they do not have network connection betweeen them i want to transfer through my pen drive
my friend told me that you can do it by enterprise manager but i dont know how please help.
2006-07-14 02:02:51 · 2 answers · asked by Nick 1 in Computers & Internet ➔ Software
1. open SQL SERVER Enterprise Manager
2. go to sql server
3. Select Management
4. Go to Backup and rightclick on it select New Backup Device
5. in filename radio u can select your pandrive or u can create backup in a file
6 take that backup in pandrive
7. On other computer u can restore that backup
2006-07-14 02:13:09 · answer #1 · answered by ashish t 2 · 0⤊ 0⤋
Make sure there is a SQL server on both computers, then do this:
http://support.microsoft.com/kb/224071/
2006-07-14 09:08:43 · answer #2 · answered by evolver 6 · 0⤊ 0⤋