Backup & Restore MS SQL 2000 Database
This is a short note I used at work to back up and restore the a MS SQL 2000 database. I have a database with the name abcengine running on a local SQL Server. I need to back up this datbase to a file, send it over to a remote SQL Server to restore it. There are two ways, which I’ve known, to back up a database. One of them is to use the Enterprise Manager to virsually back up, and another way is to use the Query Analyzer, writing the T-SQL code and run it. ...