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 |
|
schinni
Yak Posting Veteran
66 Posts |
 Posted - 2004-01-25 : 21:42:14
|
| Hello, As a part of logshipping there are backup jobs on source servercopy and restore jobs on destination server(Standby).Does anybody know how the copy is handled like what it uses ,i saw in the job it used xp_Sqlmaint ..followed by guidI am not sure what it uses..Thanks, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-26 : 12:28:59
|
| It is built into xp_sqlmaint which is an extended stored procedure. Extended stored procedures are compiled programs, so there is no way for us to see what it does. My guess though is that it is using DOS copy command. If you look at SQL Profiler, you won't see xp_cmdshell running, so it is doing it outside of SQL Server.Tara |
 |
|
|
schinni
Yak Posting Veteran
66 Posts |
Posted - 2004-01-28 : 16:48:11
|
| Thanks Tara, |
|
|
|
|
|
|
Log Shipping