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?
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!