Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
In SQL Server 2005, you can move system and user databases by specifying the new file location in the FILENAME clause of the ALTER DATABASE statement. Data, log, and full-text catalog files can be moved in this way. This may be useful in the following situations:
- Failure recovery. For example, the database is in suspect mode or has shut down, because of a hardware failure.
- Planned relocation.
- Relocation for scheduled disk maintenance.
In This Section
| Topic | Description |
|---|---|
Describes the procedures for moving user database files and full-text catalog files to a new location. |
|
Describes the procedures for moving system database files to a new location. |
See Also
Concepts
Detaching and Attaching Databases
Other Resources
ALTER DATABASE (Transact-SQL)
CREATE DATABASE (Transact-SQL)
Modifying a Database