469,572 Members | 1,351 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,572 developers. It's quick & easy.

Using SSIS to backup/restore databases

Hi there,

I'm looking to get SSIS to run database backup and restore tasks as
part of an overall process. But I have a few problems.

1. The "Backup Database Task" does not seem to allow parameterisation
- ie let you dynamically set which database is to get backed up, and
where the backup is to be put. Ultimately I'd like to put the
"database" and "backup location" into the nice xml config file I've
already got up and running, but the package configuration doesn't seem
to allow this.

2. There is no "Restore Database Task". So I've currently got "Execute
SQL Task" which excutes a sproc that does it. I guess I could
parameterise the sproc to accept @Database @Location as parameters.
Also, I suspect, to expand the sproc out to include the Backup Tasks
with an additional @BackuporRestoreFlag.

3. If I go for the sproc route, I suspect that I can't use the sproc
to backup the database which is holding the sproc? Does that mean I
need to dynamically build the sproc in SSIS as a string, then just
execute the string?

Looking for some hints on best practice here - what's a good/bad idea
from the above?

Thanks in advance

Andrew

Jun 14 '07 #1
0 6965

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Thomas Bartkus | last post: by
9 posts views Thread by Dave | last post: by
1 post views Thread by gcetti | last post: by
4 posts views Thread by Nanchil | last post: by
6 posts views Thread by Eric Herber | last post: by
3 posts views Thread by rdemyan via AccessMonster.com | last post: by
5 posts views Thread by zgh1970 | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.