MSSQL Server Backup file

[Gudea]

Hi.
I need to reach the backup file of my database so I can provide a full system backup utility for the end user of a web application (ASP.NET).
I need to "BACKUP DATABASE" and then copy the file xxxxxx.bkp to a directory in my application so I can then zip all contents including database backup and let the user download it.
It is now working in testing envirnment where I have both IIS and MS SQL Server enigne in the same machine, but once uploaded to IX Webhosting I have now two separate servers and I can't reach the file.
Is it possible to map the drive o reach the file throught netork?

Thanks
Leo

[Angela]

Yes it is possible but you might face some problems, alternatively everything you can do in enterprise manager is done by calling stored procedures so it's only a matter of discovering those procedures and how to call them to accomplish what you want. Following article which shows a statement used to restore a database and some other information which will probably help you with this task. databasejournal.com/features/mssql/article.php/2174031
EX0-101 (http://www.certpaper.com/EX0-101.htm)

[rhysmeister]

It might be simpler to script out the database and then offer that as a text file download.

[ssamayoa]

The MSSQL server is in other machine than IIS to which there is no FTP nor other file access method then if you generate a backup file you cant get it.

Also, AFAIK, you cant start backup on your database (I already tried somtime using SQL Management Studio) but the accounts haven't privilege to do that.

I do backup in local database selecting data (select * from sometable...) using link server.

May be exporing to XML each table...

I havent thing in another way.

Regards.

[sathish]

Easiest option for you is to install the publishing wizard and configure for the client and ask them to run it whenever they need.

[GradyDanner]

Hello all,
I am a new comer to this website...
Pls broaden ur support to me.
Regards.

[ProctorSchmid]

A hot greeting to everyone!
Hi there to all,i am a new member of this online community and hope to have a nice experience here