sql server new users: Database on different versions of SQL -- sql server new users

Database on different versions of SQL

Machosker
4/20/2005 8:00:05 AM

sql server new users: Hi,

I am hoping that someone can help me with a question. I could be being a
complete donkey, but my SQL experience is limited. I am working on a damage
recovery guide for my business.
We have a server running SQL 2000 Enterprise edition with a 30Gb database.
I am trying to find out if i had to build a new server from scratch, would I
be able to restore this database on a server only using a version of SQL
server 2000 standard.

Thanks in advance

Re: Database on different versions of SQL

Machosker
4/20/2005 8:50:02 AM

Thanks for the quicky reply. This is something I will have to go and check
with my boss. I have a funny feeling that we don't use the enterprise
feature. We only bought it because our server had 7.5 Gb of ram to use.

[quoted text, click to view]

Re: Database on different versions of SQL

Francesco Anti
4/20/2005 5:41:59 PM

Yes, you can restore your database, but only if it doesn't use Enterprise
Edition-specific features (Distributed partitioned views, for example).

Francesco Anti

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.