Interview Question in SQL Server 2005


 

Interview Question :: How can I backup my database from database server to another database server


Hello
How can Imy database from database server to antoher server. I amk written a programe into C#.Net 2005.

It was easy to take backup from SQLServer to device from SQL Script.

I am not getting that How can I backup database in http or ftp address.

Please help me if you can...

Thanks Manay Many in Advance
Answers to "How can I backup my database from database server to another database server"
RE: How can I backup my database from database server to another database server?

I am not sure I completely understand your question. I think what you want to do is back up a data base through HTTP or FTP? Well each MS SQL database is contained in 2 files one .MDF and one .LDF. Normally you would detach those files from the db engine and then copy them to somewhere else where you will need to attach them to a data base service. I have never tried to do it over HTTP but I am pretty sure it can be done. You will have to stop the SQL processes through your asp app and then copy those files to where you will want them.
 
Vote for this answer ::  
Update Alert Setting