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 |
|
NJDba
Starting Member
31 Posts |
 Posted - 2007-11-14 : 18:52:43
|
I would like to copy daily backup files from different folders to new location. The folder structure looks like this:C:\backup database1\database1_db_20071114.bak database2\database2_db_20071114.bak msdb\msdb_db_20071114.bak ....But I do not want to copy the backup file from some system database folders, say MSDB, so I have to choose some user database folders. What should I do? How can I extract the subfolder name from variable?Any suggestion would be appreciated. |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-14 : 19:25:15
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=92694duplicate.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
Regarding Subfolder