Discussion Locked

database backup

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
i am developing a web based application usning ASP and MS SQL. I want to take a backup of the MSSQL database through a ASP page. is this possible ?

2 replies

by glen_mcleod

Sure, you just have to get the proper command to SQL Server. You can code it yourself into an ADO Execute statement direct from your ASP page, or you can encapsulate it and call the method in a .DLL.

The syntax of the command is "BACKUP DATABASEYourDatabaseNameHere [options]". Check Books Online for the exact options you need.

Glen

This discussion is closed to new replies.