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 |
|
ytao
Starting Member
4 Posts |
 Posted - 2005-11-04 : 16:23:42
|
| I want to create device for all dbs on the server and backup those devices. Since we keep adding new database to the server, is there any way to do this job dynamically?Thanks,- Kathy |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ytao
Starting Member
4 Posts |
Posted - 2005-11-04 : 17:36:29
|
| thanks so much. But is it anyway I create backup device first and then backup all database to those devices? I am a newer for SQL Server Administrator. I just insall the SQL Server 2005, and need to backup all databases to backup devices. Please help. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-04 : 17:37:38
|
| You don't need to use devices. I haven't used them since SQL Server 6.5. You can now backup directly to files. Why do you want to use a device?Tara Kizer |
|
|
|
ytao
Starting Member
4 Posts |
Posted - 2005-11-04 : 17:49:21
|
| Is it working on SQL Server 2005? I try to use this. Thanks a lot. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-04 : 17:54:48
|
| The procs that are in those are for 2000. I have not written versions for 2005 nor have I tested them on 2005. I haven't seen anyone with procs as extensive as mine for 2005 yet.Tara Kizer |
|
|
|
|
|
|
Set up job on SQL Server 2005