Restoring SQL 7 database to SQL 2000

Can you back up a SQL 7 database and restored it to a SQL
2000 Server?
Are there any issues with doing that?
ThanksStev,
Yes, you can.You may face some issues if the database users/logins wont
match.See the below articles for details:
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Stev" <stev@.partnervest.com> wrote in message
news:019801c355ea$dc150860$a101280a@.phx.gbl...
> Can you back up a SQL 7 database and restored it to a SQL
> 2000 Server?
> Are there any issues with doing that?
> Thanks|||In addition, if you chose a Windows collation for SQL2000 during install,
you may need to convert the database to match the server collation depending
on it's use of tempdb and/or interaction with other databases on the server
as when it is restored/attached to SQL2000 it will have a SQL collation. See
BOL for more details on collation
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Stev" <stev@.partnervest.com> wrote in message
news:019801c355ea$dc150860$a101280a@.phx.gbl...
Can you back up a SQL 7 database and restored it to a SQL
2000 Server?
Are there any issues with doing that?
Thanks