Backing Up and Restoring How-to Topics (SQL Server Management Studio)
Tworzenie kopii zapasowych i przywracanie części SQL Server zapewnia ochronne niezbędne w celu ochrony ważnych danych przechowywanych w SQL Server bazy danych. Tematy w tej sekcji wyjaśniają jak używać SQL Server Management Studio do tworzenia i przywracanie baz danych, różnicowa bazy danych, dzienników transakcji i kopie zapasowe plików i grupa plików. However, for partial or copy-only backups, you must use the Transact-SQLBACKUP statement with the PARTIAL or COPY_ONLY option, respectively.
In This Section
Tematy opisy wykonywania określonych zadań dotyczące wykonywania kopii zapasowych
How to: Back Up a Transaction Log (SQL Server Management Studio)
How to: Back Up the Tail of the Transaction Log (SQL Server Management Studio)
How to: Back Up Files and Filegroups (SQL Server Management Studio)
How to: Back Up to Tape or Disk (SQL Server Management Studio)
How to: Create a Differential Database Backup (SQL Server Management Studio)
How to: Define a Logical Backup Device for a Disk File (SQL Server Management Studio)
How to: Define a Logical Backup Device for a Tape Drive (SQL Server Management Studio)
How to: Delete a Backup Device (SQL Server Management Studio)
How to: Set the Expiration Date on a Backup (SQL Server Management Studio)
How to: View the Contents of a Backup Tape or File (SQL Server Management Studio)
How to: View the Data and Log Files In a Backup Set (SQL Server Management Studio)
How to: View the Properties and Contents of a Logical Backup Device (SQL Server Management Studio)
Tematy opisy wykonywania określonych zadań dotyczące przywracanie
How to: Restore a Backup from a Device (SQL Server Management Studio)
How to: Restore a Database Backup (SQL Server Management Studio)
How to: Create a New Database From an Existing Database Backup (SQL Server Management Studio)
How to: Restore a Differential Database Backup (SQL Server Management Studio)
How to: Restore a Database to a Marked Transaction (SQL Server Management Studio)
How to: Restore Files and Filegroups (SQL Server Management Studio)
How to: Restore a Transaction Log Backup (SQL Server Management Studio)
How to: Restore to a Point in Time (SQL Server Management Studio)