We have a client who has refused until now to update his server and software. The vertical application is no longer supported by the vendor and is a custom application. So the option we have is to move the sql databases which are currently hosted on a SBS 2003 server. We are installing a test server 2012 running SQL 2014 and will try to run the client app in a VM.
What is the easiest and best way to export the sql data from the old sql to the new. All of the sql backup apps that run on sbs 2003 will not run on Server 2012, that we have tried.
I'm not a sql expert so need some walking through it.
You'll need to upgrade it to a middle version since SQL 2014 doesn't recognize MSSQL 2000 databases.
First thing to do is to update your MSSQL 2000 instance with SP4 (http://www.microsoft.com/en-us/download/details.aspx?id=18290).
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed