Microsoft SQL Server, part of the Windows Server System, is a total relational database management package for data management. It is the foundation of modern e-commerce and business intelligence applications. Microsoft SQL Server can be used to develop and implement these kinds of applications very quickly. In this process, the software can grow along with the application. For more information on Microsoft SQL Server, please visit http://www.microsoft.com/sql/.
A relational database stores data in tables that have relations to one another, instead of in one big long list. Speed and flexibility are two major advantages of this database type. SQL stands for Structured Query Language. SQL is the standard language for accessing databases. SQL statements are used to execute certain tasks, such as updating data in a database, or retrieving data from a database. In addition to SQL, Microsoft SQL Server also supports Transact-SQL (T-SQL), which is a superset of SQL with additional features such as support for stored procedures.
Microsoft SQL Server Database Version
You will receive a Microsoft SQL Server 2008 database. The maximum size of the database is 150 MB. You can access the database using host name sql.uwdomein.nl.
You will receive a login ID (user name) and password for your database. You will be assigned the role “db_securityadmin” for this user.
Microsoft SQL Server Database Maintenance
You can maintain a Microsoft SQL Server database using a tool such as Microsoft SQL Server Enterprise Manager or Aqua data studio. The latter program is suitable for several kinds of databases. For instance, you can also use it to maintain a MySQL database. You can use these tools to manage your database from your own computer.
Make Microsoft SQL Server Database Backup
A simple way to make backups of your MS-SQL database is the import/export feature in SQL Server Management Studio. This allows you to export all data for each table to a text file, which you will then save securely on your own system.
You do all of this in the trusted SQL Server Management Studio.
First, log into the database server, then right-click on the database in question. Then, in the context menu, select ‘tasks’, then ‘export data…’. After this, you will go through the wizard and receive a prompt asking which database and table you want to make a backup of.
You will also have several options for where you want to save the backup, such as another database server, an Excel spreadsheet or a flat text file.
Use the same method to import data, but select option ‘import data…’ instead.