?
Solved

Back up SQL Server 2008 r2 and restore on another server

Posted on 2011-10-07
2
Medium Priority
?
227 Views
Last Modified: 2012-06-21
I am looking for assistance on how to back up a SQL Server 2008r2 and restoring it on another server.

We have 2 Virtual machines
I want to capture the entire SQL Server including some SSIS deployed packages and restore these on another server. I tried backing up individual databases but some return a message indicating that it was unable because it was a different instance.

We are using Windows server 2008 with SQL Server 2008 r2 on both VMs
Is there a way to transfer all the dbs and restore them on another Server?
0
Comment
Question by:Mswetsky
2 Comments
 
LVL 4

Accepted Solution

by:
MarioAlcaide earned 1000 total points
ID: 36930358
Hi,

The following manual will guide you:

http://msdn.microsoft.com/en-us/library/ms190447.aspx
0
 
LVL 25

Assisted Solution

by:jogos
jogos earned 1000 total points
ID: 36930846
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question