ASP SQLServer Backup Script ?

• qt11

  SSC Rookie

  Points: 45

  More actions

  June 22, 2006 at 10:08 am

  #153049

  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

• Fred Williams-134192

  SSCrazy

  Points: 2532

  More actions

  June 23, 2006 at 11:55 pm

  #645704

  The basic SQL for a db backup is:

  BACKUP DATABASE MyDatabaseName TO DISK = 'x:\MyDirectory\MySubDir\MyBackupFileName.BAK'