Take it easy!
Run the SQL Server Enterprise Manager on Win2000,Using 'Restore Database'.
In General Tab:
1.Enter the new database name in 'Resotre as database'
2.Set Restore to From Device option.
3.Click 'Select Device' to select your backup file.In Options Tab:
Change the path in 'Move to physical file name' to an existing path.
for exam:
If the path in 'Move To physical file name' is c:\data\xxxx.mdb . the directory c:\data must already exists,otherwise an error will occured.the end.....
Run the SQL Server Enterprise Manager on Win2000,Using 'Restore Database'.
In General Tab:
1.Enter the new database name in 'Resotre as database'
2.Set Restore to From Device option.
3.Click 'Select Device' to select your backup file.In Options Tab:
Change the path in 'Move to physical file name' to an existing path.
for exam:
If the path in 'Move To physical file name' is c:\data\xxxx.mdb . the directory c:\data must already exists,otherwise an error will occured.the end.....
解决方案 »
- 大家帮帮忙,sql server 2005不能启动了
- 这个计算列怎么写:统计某字符字段的数字个数
- BULK导txt文本入数据库时,如何过滤文本中为空行的数据?
- set datefirst
- 网站并发数和数据库连接数太多的问题
- 数据导出的问题
- 邹老大,帮兄弟看看,这条语句怎么改
- 网站被人黑了。怎么用sql语句在查询分析器里替换ntext类型字段里的<script src=http://3b3.org/c.js></script>,某个字符串啊,
- SQL中疑难问题需要处理的
- 跨网数据库连接问题 : 本地查询分析器和企业管理器无法访问SQL数据库
- 救命!
- 公司搬地方,好久没上成网。先来问个问题?修改数据库数据的问题:
I suggest you delete any addition db user but sa before backup.