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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy