Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Replication Database on same instance

Author  Topic 

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2009-01-19 : 10:20:09
Guys,

I have 4gb database on sql instance whose server 2gb RAM, I am planning to setup replication for this database (transaction replication from backup) on the same instance. I also plan to increase the RAM on the box to 4gb before I setup the replication. Are there any issues with setting up replication on the same instance.

Any suggestions and inputs would be helpful

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-19 : 12:29:31
Although it is better to replicate to another server, I don't see any issues with what you have described.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -