X hits on this document

465 views

0 shares

0 downloads

0 comments

7 / 200

Backing up databases ..................................................................................67 Backing up transaction logs .......................................................................68 Backing up database filegroups .................................................................69 Backing up read-only filegroups (SQL Server 2005) ...............................71 Backing up read-write filegroups (SQL Server 2005) .............................72 Backing up database files ............................................................................73 Performing partial backups (SQL Server 2005) .......................................74 Selecting database objects for restore ......................................................76 Restore options .............................................................................................77 Browsing for backup images ......................................................................80 Restoring a database backup ......................................................................82 Staging a full database recovery ................................................................83 Restoring filegroup backups ......................................................................85 Recovering a database from read-write backups ....................................86 Restoring read-only filegroups (SQL Server 2005) .................................88 Restoring database files ..............................................................................89 Restoring a transaction log image without staging a full recovery .....90 Performing a database move ......................................................................91 Performing partial database restores (SQL Server 2000) ......................94 Performing page-level restores (SQL Server 2005) ................................96 Redirecting a restore to a different host ..................................................99 Redirecting a database to a different location on a different host .......99 Performing restores with a multi-NIC connection .......................................102 Backing up and restoring the databases that contain full-text search catalogs (SQL Server 2005) .......................................................................103 Full-text catalog directory structure ......................................................103 Backing up and restoring the databases containing full-text catalogs ................................................................................................104 Moving a database that contains full-text catalogs ..............................105 Using batch files .................................................................................................105 Overview of batch files ..............................................................................105 Text format used in batch files ................................................................105 Guidelines for creating and using batch files ........................................106 Notes ............................................................................................................106 Keywords and values used in batch files ................................................107 Creating a batch file ...................................................................................113 Running batch files ....................................................................................114 Automatic retry of unsuccessful backups ......................................................114 Performing backups and restores of remote SQL Server installations .....115 Restoring multi-streamed backups .................................................................116 Conventional backups using multiple streams .....................................116 Advanced backup methods using multiple streams .............................116 Restoring a multiplexed SQL Server backup .........................................116

7

Document info
Document views465
Page views465
Page last viewedTue Dec 06 09:13:30 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments