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 |
|
sepide82
Starting Member
2 Posts |
 Posted - 2009-03-17 : 14:59:37
|
| How to overwrite or append(back up) database table on a tape by schedule in SQL server?plz help meI want to take back up from two tables in SQL server on a tape automaticly(by schedule), first table must overwrite on tape after finishing that the second table must append on thesame tapebau i dont khow how i can do it automaticlly every night(not manualy)even in the SQL server enterpriCe manager or by transact SQLplz help meeeee |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-03-17 : 15:02:33
|
| You can schedule a job for this. |
 |
|
|
sepide82
Starting Member
2 Posts |
Posted - 2009-03-18 : 13:44:59
|
quote:
Originally posted by sakets_2000
You can schedule a job for this.
yes, but how can i specify that the first table overwrite on the tape and the second one append on the tape??help me in detail plzthx |
|
|
|
|
|
|
how to schedule back up on the tape in SQL server