如何备份SQLServer [英] How to backup SQLServer

问题描述

大家好，我想问一个关于sql 2005的问题，当我在sql中创建数据库时，我想备份数据库.例如:mydata.sql

当我要转储数据库时，我创建一个新查询，然后创建coppy文件mydata.sql并将其定位到此.

我不知道创建文件备份.

非常感谢

hello everybody, I want to ask a question about sql 2005, when i creat a database in sql, i want to back up database. eg: mydata.sql

when i want to retorse my database, i creat new query then coppy file mydata.sql and pase to this.

I dont know creat file backup.

Thank you so much

推荐答案

什么是mydata.sql?

使用TSQL备份阅读 [

What is mydata.sql?

To backup using TSQL Read[^]

And there are other options also like Google, Read books, SQL Server books online etc.

复制文件不是备份

http://msdn.microsoft.com/en-us/library/ms187510.aspx [ ^ ]

Copying files is not a backup

http://msdn.microsoft.com/en-us/library/ms187510.aspx[^]

继续阅读BACKUP和RESTORE，也可以进行ATTACH和DETACH.

Read up on BACKUP and RESTORE also ATTACH and DETACH.

这篇关于如何备份SQLServer的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！