June 22, 2006 at 10:08 am
Hey guys...
I have an ASP based website which uses a SQLServer db, however I do not have any access to SQLServer admin tools. I've tried using a number of ASP apps to give me a front end in the db, however none have worked.
The site is being hosted by a friend how is too busy with paying customers to do this for me, so i'm on my own.
I only have access to basic ASP on the server and wondered if there was a way to run a script from ASP that would create a full backup of the db and place the file somewhere in my ftp space...
I've tried ASPMyAdmin by Sukalyan Chakraborty, however the connection strings just don't want to work on the server i use. MyLittleAdmin does connect okay, however expensive to purchase the version which lets you do the backup. My website is a community site, which doesn't make any income, so funds a tight.
Everything db admin wise, i do through running SQL statements within ASP pages.
I hope this makes sense....
Cheers
A
June 23, 2006 at 11:55 pm
The basic SQL for a db backup is:
BACKUP DATABASE MyDatabaseName TO DISK = 'x:\MyDirectory\MySubDir\MyBackupFileName.BAK'
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply