I need a solution for the following:
I have a mssql database on windows 2008 r2 server, which is constantly increasing in size and is currently at 800mb. Sometimes the network crashes and the website is down and that also means the database is down as well, so i want solution for the following:
I want to copy the mssql db to another msql db on another server automatically without me having to do anything using a custom script, i know it is 800mb but i do not have the time to manually backup the db and transfer on a daily basis. The task is that all the tables to copy to another db and most likely this needs to be done with custom script on scheduled tasks (cron).
16 freelancere byder i gennemsnit $55 for dette job
Hi, I propose to use sql server scheduller. Or if it is not possible in your environment, I can create a .net service to do that. Let me know detail of your table. Regards