Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

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 ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server 2005

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

Top Tags