| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-05-15 : 09:14:51
|
| Is it possible to have individual backup file for each DB, possibly in the form of DB_Name_YYYYMMDD.BAK while backing up on – NETWORK?------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-15 : 09:33:50
|
| "while backing up on – NETWORK?"What do you mean? Yes you can do as you said with Maintenance plan and choose subfolders for each database -it will create MM-DD-YY for you in bak files. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-15 : 09:35:24
|
| you can not do that when the backup is NOT on local server.------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-15 : 09:54:43
|
| what? Did you try with maintenance plan ? you should be able to. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-15 : 10:09:35
|
| I tried. It is not possible. Or am I missing something? When doing the network backup you need to create a DEVICE. this is just a container. All the susequent backups will be inside one container. There will not be individual files. ------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-15 : 10:20:48
|
| If you do like i said, it will create seperate folder for each database you specify in Network share you have. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-05-15 : 10:22:07
|
| you will not be able to pick up the path (like browse and click) but you can specify italso it might be good to just schedule the sproc that will create the backup files instead of relying on the maintenance wizardthat's just me and how i would do it--------------------keeping it simple... |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-15 : 10:28:33
|
| That's right,you have to specify. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-15 : 10:31:17
|
| Ok. I will try this. Will be back soon.------------------------I think, therefore I am - Rene Descartes |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-15 : 10:42:39
|
| Its working!Thanks Sodeep. Thanks Jen!------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
Network backup