Solved

instead of copy a SQL DB make a replica

Posted on 2014-10-17
16
96 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 45

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 45

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
 

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 45

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 45

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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 45

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 45

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 45

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 45

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

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…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now