This section describes to database backup process with the database system in use.
MS SQL Server
The backup settings are performed in the SQL Server Enterprise Manager that is a part of the SQL Server installation. Automatic backup can be scheduled as a task in the Management – Database Maintenance Plans folder.
SQL Express
If you use an SQL Express database, you can back up the corresponding two data files with the mdf and ldf file extensions. These two files are saved by default in the C:\Program Files\Microsoft SQL Server\MSSQL\Data folder. Before you run the backup, you will need to stop the SQL Server (SQLEXPRESS) service, e.g. with the following command:
net stop MSSQL$SQLEXPRESS
Once the backup is finished, run SQL Express again with the following command:
net start MSSQL$SQLEXPRESS
If you cannot stop SQL Express for the backup process, use the following command:
sqlcmd -S .\sqlexpress -i backup.sql
This command will log you in as a user to the database engine using the integrated Windows logon (the user account from which the command is run must have the necessary permissions for SQL Express) and run the script from the backup.sql file. This script will create the backup.
The backup.sql file content:
BACKUP DATABASE database_name TO DISK = 'C:\Backup\ambackup.bak' WITH INIT
This script will create a backup copy of the database_name database to the file c:\Backup\ambackup.bak (the folder C:\Backup\ must exist). The old backup file will be overwritten with the new one each time you run the script.
Did not find what you were looking for? Ask our technical support team.
|