Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
akpaga
Constraint Violating Yak Guru
331 Posts |
 Posted - 2008-06-25 : 11:28:51
|
| hi i have two databases that i need to backup and store on a tape or disk which i need to send to someone else who would like to use those back up databases on their local machine.how can i do that?thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-25 : 12:53:06
|
| Just backup the database to a file then use xcopy to move the file to their machine. You can call xcopy via xp_cmdshell. Otherwise, place the backup file in a folder that has a network share on it so that the user can grab it themselves.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-25 : 12:54:06
|
| Read Backup Command/syntax in Books online. And after that copy it to other local machine. |
|
|
|
|
|
|
back up of databases