megan
Perch
HI - I have a set of stored procedures that allows me to backup a local sql server 2000 database, and then restore it using a coldfusion script - works great locally
I decided to test just the backup part on my jodohost sql server database and was able to create the backup stored procedure, but then when I tried running it using query analyzer , I got a permissions error message.
the stored procedure takes just 2 params, the name of the database and the path to the folder where the .bak file would be stored.
I have two questions - how would I go about getting the right permissions to create a backup this way, and what path would I use to store the bak file if the sql server db is on a different server than the regular website.
any ideas ??? is this do-able at all? (I am wanting to create a coldfusion db backup system) thanks, megan
I decided to test just the backup part on my jodohost sql server database and was able to create the backup stored procedure, but then when I tried running it using query analyzer , I got a permissions error message.
the stored procedure takes just 2 params, the name of the database and the path to the folder where the .bak file would be stored.
I have two questions - how would I go about getting the right permissions to create a backup this way, and what path would I use to store the bak file if the sql server db is on a different server than the regular website.
any ideas ??? is this do-able at all? (I am wanting to create a coldfusion db backup system) thanks, megan