Hướng dẫn backup database sql server 2005 ra file mdf
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Show Back up and restore: System databases (SQL Server)
In this articleApplies to: SQL Server maintains a set of system-level databases, called system databases, which are essential for the operation of a server instance. Several of the system databases must be backed up after every significant update. The system databases that you must always back up include The following table summarizes all of the system databases. System database Description Backups required? Recovery model Comments master The database that records all of the system level information for a SQL Server system. Yes Simple Back up Best practice: We recommend that you create only full database backups of msdb The database used by SQL Server Agent for scheduling alerts and jobs, and for recording operators. Note: You can perform a file-based or a disk-based backup on the `master`1 file by treating the file as if it were a binary (`master`3) file, instead of a database file. But you can't use SQL Server restore on the backups. Restoring a backup copy of `master`1 can only be done manually, and you must be careful not to overwrite the current Resource database with an out-of-date or potentially insecure version. tempdb A workspace for holding temporary or intermediate result sets. This database is re-created every time an instance of SQL Server is started. When the server instance is shut down, any data in 1 To learn the current recovery model of the model, see View or change the recovery model of a database (SQL Server) or sys.databases (Transact-SQL). Limitations on restoring system databasesSystem databases can be restored only from backups that are created on the version of SQL Server that the server instance is currently running. For example, to restore a system database on a server instance that is running SQL Server 2016 (13.x) with Service Pack 1, you must use a database backup that was created after the server instance was upgraded to SQL Server 2016 (13.x) SP 1. To restore any database, the instance of SQL Server must be running. Startup of an instance of SQL Server requires that the
Under some circumstances, problems recovering the |