SQL Server version and backup

Version Information

 

SQL Server 2008 SP1 ----------------- 655

SQL Server 2008 RTM2 ----------------- 661

SQL Server 2005 ----------------- 612

SQL Server 2005 ----------------- 611

SQL Server 2000 ----------------- 539

 

 

Backup

Database files, I .e. mdf files, can be directly copied to other places for use.

Note: You must stop the database service first.

Usage: attach a database

 

Backup file, that is, bak File

Generate: Right-click the database, and choose task> Backup.

Use: task --> Restore database