Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

instead of copy a SQL DB make a replica

Posted on 2014-10-17
16
Medium Priority
?
108 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 53

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 53

Accepted Solution

by:
Vitor Montalvão earned 2000 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
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 

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 53

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 53

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 53

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 53

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 53

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 53

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

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
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 …

564 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