SQL Server 2005 Notes

First, the Migration database

1. Take the corresponding database offline

2. Migrating the corresponding database files
   

3. Execute the command above the master database to change the file directory of the corresponding database

Alert Database zxta Modify file
(
Name=zxta,filename= ' E:\NEW\zxta.mdf '
)
Alert Database zxta Modify file
(
Name=zxta.log,filename= ' E:\NEW\zxta_log.ldf '
)

4. Online

Note: You can also use the "detach-Attach" method for database migration

Second, database backup

Completion of the database log file will record the specific time and corresponding action records, you can restore to any point in time

The bulk-logged database log file does not log the time only, it cannot restore a specific point in time

Simple database log files are overwritten by write

This article is from the "Sim blog," Please make sure to keep this source http://mitac.blog.51cto.com/1081911/1564966

SQL Server 2005 Notes