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 |
|
juerisnai
Starting Member
1 Post |
 Posted - 2008-06-27 : 05:30:46
|
| Hi!I have to backup a lot of databases and I only use two directories to save that files. My idea is to create an environment variable to store the path.Ex: backup1 --> C:\backup\backup1 backup2 --> C:\backup\backup2Is it possible? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-06-27 : 07:16:23
|
| There is no such thing as environment or global variables in sql server.- Lumbago |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-27 : 08:04:31
|
| Do you mean you want to have Timestamp on each backup files? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-27 : 12:44:12
|
quote:
Originally posted by Lumbago
There is no such thing as environment or global variables in sql server.- Lumbago
There is in SSIS or DTS Packages. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-28 : 00:33:01
|
| Will you backup db in ssis or dts? |
|
|
|
|
|
|
[SQL2005] Use an environment variable in a backup