我想从sql 2005复制数据库并将其还原到sql2000 [英] i want to copy database from sql 2005 and restore it to sql2000

问题描述

error: 3205; too many backups devices specified for backup or restore only 64 are allowed restore filelist is terminating abnormally.  

注意:我想复制sqlserver 2005的数据库备份并将其还原到
sql server 2000显示该错误.

note : i want to copy a database backup of sqlserver 2005 and restore it to
sql server 2000 showing that error.

推荐答案

数据库2005无法在2000年恢复，因为向后兼容性问题

database 2005 can''t restore in 2000 becoz of backward compatibility issue

您需要从数据库备份和还原历史记录中删除所有备份设备
单击此处了解更多有关使用文件或备份设备进行备份和还原的信息 [如何删除备份设备 [

you need to remove all backup devices from your database backup and restore history
click here to know more for backup and restore using file or backup device[^]
and also how to remove backup device[^]

，您还可以为整个脚本生成脚本数据库并在mssql 2000上运行

and also you can generate script for whole database and run on mssql 2000

这篇关于我想从sql 2005复制数据库并将其还原到sql2000的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！