Moving Database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Moving Database

Author

Topic

Kotti
Posting Yak Master

129 Posts

Posted - 2009-01-30 : 11:10:06

Hi friends

I am having database named MF in Mssql server 2005 ,i need to move the datebase to Mssql 2000 .May i know how to do this ?

when i tried to move using DTS package only tables are moving but not the stored procedures.

Please help me regarding this.

Thanks in Advance

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-30 : 11:13:54

Script it out.

Rajesh Jonnalagadda
Starting Member

45 Posts

Posted - 2009-01-31 : 01:45:07

Try this,

BACKUP DATABASE Test_Forums TO DISK = 'D:\Test.bak'

and to restore

RESTORE Test_Forums
FROM DISK = 'D:\Test.bak'

Rajesh Jonnalagadda
[url="http://www.ggktech.com
"]GGK TECH[/url]

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-31 : 09:09:13

You can't backup and restore from SQL 2005 to SQL 2000.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources