如何备份SQL Server 2000数据库表 [英] How to take back up of sql server 2000 database table

问题描述

在我使用SQL Server2005之前.SQLServer2000.im的新手需要在SQL Server2000中重新使用.

before i use SQL Server2005..i''m new to SQL server2000.i m n need to take back up in SQL server2000.

推荐答案

从现有数据库进行备份，这是一个简单的TSQL备份命令:

If you want to take a backup from existing database here is a simple TSQL backup command :

BACKUP DATABASE [NorthWind] TO  
	DISK = N'c:\backup.dat' 
	WITH NOFORMAT, NOINIT,  NAME = N'Northwind Backup'

在这里查看语法:
http://msdn.microsoft.com/en-us/library/ms186865.aspx [ ^ ]

要恢复数据，请使用以下命令:

See the syntax here :
http://msdn.microsoft.com/en-us/library/ms186865.aspx[^]

To restore back the data use this command :

RESTORE DATABASE [Northwind] FROM  DISK = N'c:\backup.dat' WITH  FILE = 1,  NOUNLOAD,  REPLACE,  STATS = 10

希望对您有所帮助.

Hope it helps.

非常感谢..它可以成功工作.如何还原它?

Thanks a lot..it works successfully.how to restore it?

如果要还原数据库备份(SQL服务器管理Studio).

试试这个，
http://msdn.microsoft.com/en-us/library/ms177429.aspx [ ^ ]
http://msdn.microsoft.com/en-us/library/ms188223.aspx [ ^ ]

if you want to Restore a Database Backup (SQL Server Management Studio).

try this,
http://msdn.microsoft.com/en-us/library/ms177429.aspx[^]
http://msdn.microsoft.com/en-us/library/ms188223.aspx[^]

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