You want to get a backup of your MS SQL database to your local computer.
You can backup your MS SQL database with SQL Server Management Studio tool
Click Start -> Programs -> Microsoft SQL Server 2008 (2005) -> SQL Server Management Studio to begin program.
You can login your SQL Server Instance with Windows Authentication or MS SQL Server Authentication to login:
A. In Object Explorer, click the server name to expand the server tree. B. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. C. Right-click the Database, point to Tasks, and then click Back Up. D. The Back Up Database dialog box appears.
Select Disk for the type of backup destination and click Add.
Click ...
Select a path and entry of your backup file name and click OK .
You will see the backup file.
You will see the windows while finished.
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add support@databasemart.com to your trusted senders list in your email software.