September 18, 2007 at 5:38 pm
Hello everybody ,
I need to create a automation job for 2005 analysis services database to backup a database every night . i dont have sql server agent to create a job. I was told about a method to create a batch file and than use ssis or something similar to execute the job.
can anyone please help me out in guiding me with proper documentation to perform this procedure so that i can create a automation job without the help of sql server agent to create a backup job every night for anaylysis services 2005 database ......analysis services 2005 only
Thanks in advance
Yukon DBA
September 18, 2007 at 8:19 pm
Yes you can run an SSIS package from command line (batch or what not) just as you could use dtsrun.exe to do the same in 2K. the executable name is dtexec. the link below should get you going
http://www.mssqltips.com/tip.asp?tip=1059
in the SSIS package you can execute the BACKUP DATABASE statement or throw the backup database task in there which is more gui orientated if that is your better fell for doing the package development
Hope that gets you going
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply