Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

instead of copy a SQL DB make a replica

Posted on 2014-10-17
16
100 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 48

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 48

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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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 48

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 48

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 48

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 48

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 48

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 48

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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
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 their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

828 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