Home > IT Answers > SQL Server > Backing up and copying a database across SQL ...
Help

Question

Asked:
Asked By:
Nov 21 2008   8:05 PM GMT
SQL Server Ask the Experts   2275 pts.

Backing up and copying a database across SQL Servers


SQL Server 2005, SQL Server backup and restore, SQL Server databases

I have SQL Sever 2005 on both servers A and B, although I do not have SQL Studio Manager on server A. I would like to backup a SQL database from server B onto server A, and then copy it over to server B and restore it to the same database. How would I go about doing this?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
-1
Click to Vote:
  •   0
  •  -1
Last Answered: Nov 21 2008  8:13 PM GMT  by Technochic   35525 pts.




Here is a helpful guide for you.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register