Solved

instead of copy a SQL DB make a replica

Posted on 2014-10-17
16
102 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
[X]
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
  • 8
  • 8
16 Comments
 
LVL 50

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 50

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
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 

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 50

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 50

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 50

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 50

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 50

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 50

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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
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…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

690 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