Backup Script

[risoam]

Here's my problem. I have an ASP based website based off of SQL server. The webhost does not provide an automatic means for me to backup my own database. The schedulig feature in the SQL administrative tools are disabled for some reason. The webhost was grateful enough though to set up an FTP account for me so that I can do the back up manually (initiate it) and then I could download the file. Is there a script, either being a stored procedure or even a SQL statemnt that I can perform a backup? I could have it do it on the first access of the site that day using some ASP code. I haven't been able to find any. Thanks for your help!

 

[tlbroadbent]

Look up BACKUP in SQL Books Online.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ba-bz_35ww.asp

How to create a database backup (Transact-SQL)

http://msdn.microsoft.com/library/en-us/howtosql/ht_7_backpc_7cft.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[logicalman]

I am at a loss as to why you cannot simply request your DBA to create a maintenance plan to backup the said DB each morning (or night). If you need the resultant file to be placed on a particulat server, this can be specified in the plan.

HTH

Tony