Solved

instead of copy a SQL DB make a replica

Posted on 2014-10-17
16
101 Views
Last Modified: 2014-10-17
Hi Experts,

I have a SQL2008 server with some DBs.
And now I installed a test server with SQL2012.

I need to copy my DB to the new test SQL server.
Is it possible to do this with a task from SQL Management Studio ?
What about to create a mirror or a replica ?
And if its possible how to do this ?
0
Comment
Question by:Eprs_Admin
  • 8
  • 8
16 Comments
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40386128
What you need? A one shot copy or something to be always up to date?
If it's a one shot copy then I'll recommend to restore the DB in SQL Server 2012 from a backup of the DB in SQL Server 2008. After restore it in SQL Server 2012 you'll need to change the database compatibility to SQL Server 2012.

To be always up to date, mirroring and log shipping aren't good because the database wouldn't be available. For that I'll recommend a Snapshot or Replication.
0
 

Author Comment

by:Eprs_Admin
ID: 40386185
I need a one shot copy.
0
 
LVL 49

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40386193
Then just run a backup for you SQL Server 2008 database and restore it on SQL Server 2012. Just simple as that.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:Eprs_Admin
ID: 40386201
ok will do it.
Both Servers are in a workgroup.
But for some reason I cannot connect the new server - Error 5 Access Denied.
I can ping the new server from the old one and vica verca.
Do you have any hints ?
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40386203
It's a general error. Can't do nothing but guess.
Wrong user name? Wrong password?
Do you have permissions for remote login?
Are you local administrator of the server?
0
 

Author Comment

by:Eprs_Admin
ID: 40386204
I can login with the SA account.
Where do I set the permissions for remote login ?
0
 

Author Comment

by:Eprs_Admin
ID: 40386206
see the error

sql error 5
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40386210
I meant remote login with Terminal Services / Remote Desktop.
Since you can login with SA account then it's all fine. You can continue.
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40386215
Why are you using the "Copy Database Wizard"?
0
 

Author Comment

by:Eprs_Admin
ID: 40386250
The Copy Wizard is available for use, just want to try it.
But on the second step I always get the error -> Access denied.
And I don´t know why.

When I use Backup Exec to restore the DB, I also have problems to connect.
But why ?
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40386258
You need to give me more information. In which server are you logged in and what exactly you are trying to perform.

Are you a DBA or someone that it's only trying to help? I need to know that to see if I'll lead you with T-SQL commands or GUI options.
0
 

Author Comment

by:Eprs_Admin
ID: 40386269
On Server 1 is a DB, this needs to be copied to server 2.
Both servers just in workgroups.
I can ping each server from each other.

When I start the SQL GUI I can login with Windows Auth and SA Account.
But I cannot select the DB of the other server, then I get Access Denied.

I am a DBA.
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40386275
Can you perform a backup command on SQL Server 2008 database?
0
 

Author Comment

by:Eprs_Admin
ID: 40386278
sure
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40386280
Then do it and when finished copy the backup file to the SQL Server 2012 machine.
0
 

Author Comment

by:Eprs_Admin
ID: 40386325
ok then I go this way. Thanks.
0

Featured Post

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Lock down RDS desktop. 3 46
Folder Redirection GPO 8 52
SQL to JSON 14 40
Trying to understand why my Index is so large 12 18
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this Micro Tutorial viewers will learn how to restore single file or folder from Bare Metal backup image of their system. Tutorial shows how to restore files and folders from system backup. Often it is not needed to restore entire system when onl…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

726 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