August 29, 2012 at 10:35 pm
I have two SQL Server Instances (Ver.2012) installed in two boxes. Server A is in Box-I and Server B is in Box-II. Box-II is in a different network. The database is having an 85GB big MDF and 55GB big LDF file. I need to replicate this in the Server B. What is the best way to do this with least downtime ?
Is it Detach, Copy, Attach OR Backup, Restore ?
August 29, 2012 at 11:51 pm
Backup-Restore.
Transaction replication has option called initialize from backup.
August 30, 2012 at 4:57 am
SQL Kidu (8/29/2012)
I have two SQL Server Instances (Ver.2012) installed in two boxes. Server A is in Box-I and Server B is in Box-II. Box-II is in a different network. The database is having an 85GB big MDF and 55GB big LDF file. I need to replicate this in the Server B. What is the best way to do this with least downtime ?Is it Detach, Copy, Attach OR Backup, Restore ?
Want to be clear here, Do you need to actually replicate the data realtime or just a one time copy of the data?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2012 at 4:59 am
We need both versions in sync
August 30, 2012 at 5:46 am
do the secondary databases need to be readable?
what edition of sql server 2012 are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2012 at 5:56 am
Yeah. Off course..
I am using SQL 2012 Enterprise Edition ( Running on Windows 7 Professional Version with SP1 )
August 30, 2012 at 7:57 am
And do the secondary databases need to be writeable as well, or can they be Read-Only copies?
(the reason for all of these questions is that there are over a dozen different ways to replicate a database in SQL Server. Which one is best for you depends on the answers to these questions).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 30, 2012 at 8:19 am
They do indeed differ, although this does somewhat limit the options
SQL Kidu (8/30/2012)
Running on Windows 7 Professional Version with SP1
Interesting and never tried it, but SQL Server 2012 Ent does not list Windows 7 as a valid OS platform!
http://msdn.microsoft.com/en-us/library/ms143506.aspx#top_principal
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2012 at 8:58 am
Perry Whittle (8/30/2012)
They do indeed differ, although this does somewhat limit the optionsSQL Kidu (8/30/2012)
Running on Windows 7 Professional Version with SP1Interesting and never tried it, but SQL Server 2012 Ent does not list Windows 7 as a valid OS platform!
http://msdn.microsoft.com/en-us/library/ms143506.aspx#top_principal
IIRC, Standard and Enterprise usually only technically supported the Server OS's, not the desktop ones.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 30, 2012 at 9:07 am
2012 Std definitely lists Windows 7 as a valid platform but BI and Ent don't, it's in the link i posted
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply