troubleshooting Question

SQL Server 2000 Replication to same server?

Avatar of eangle
eangle asked on
Microsoft SQL Server
4 Comments2 Solutions253 ViewsLast Modified:
Have a SQL Server 2000 Standard SP4 server hosting a production accounting database.  Want to make a daily copy to a non production/test database on same server so accountants can work with current data without affecting production.  Want to automate this so I don't have to make a manual copy every day of course.  

Will Replication work for this or will this only work for replicating to a remote/separate server?  Is there a better way to accomplish this task using a different method altogether?  
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros