An offline database is unavailable to users. An offline database icon displays a broken line across the database.
To take a database offline/online
To attach a database
Right-click a database under the Databases node in the Object Explorer, and select Tasks | Attach Database.
Click Add to select the database file (*.mdf).
Complete the fields as necessary. Review the following for additional information:
Databases to attach |
Description |
Database File Location (*.mdf) |
Click |
Attach As |
Update the name of the database, if needed. |
Database details |
Description |
Original file name |
The data and log file names display for the selected database. |
File type |
The file type (data or log) displays. |
Current file path |
The current file path displays. Click |
Message |
Any messages for the selected file display. |
Tips:
To detach a database
Select the Databases node in the Object Explorer.
Complete the fields as necessary. Review the following for additional information:
Drop Connections |
Select this checkbox to drop connections for the detached database. |
Update Statistics |
Select this checkbox to update statistics for the detached database. |
Keep Full Text Catalogs |
Select this checkbox to keep full text catalogs for the detached database. |
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
Database snapshot is a read-only copy of the database, taken at the moment of snapshot's creation. Unlike backup a snapshot requires less hard disk space and is recommended for report purposes.
Reverting to database snapshot overwrites the updates made on the source database and rebuilds log file, that provides no possibility to roll forward the changes.
To create a database snapshot
To revert a database snapshot
Notes: The following restrictions exist when reverting database snapshots:
© ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center