Tuesday, February 21, 2012

restore

I have a database file backup from SQL Server 2000.
Can i restore it on SQL Server 2005?Win wrote:
> I have a database file backup from SQL Server 2000.
> Can i restore it on SQL Server 2005?
>
>
IMHO yes :)
regards
SW|||Yes, but be aware that it will be in SS2000 compatibility level. If you want
to use SS2005 features in the database you will have to change it to SS2005
in the Options menu.
Good luck :-)
"Win" wrote:
> I have a database file backup from SQL Server 2000.
> Can i restore it on SQL Server 2005?
>
>|||This is a multi-part message in MIME format.
--010605060902050401060003
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Skaale wrote:
> Yes, but be aware that it will be in SS2000 compatibility level. If you want
> to use SS2005 features in the database you will have to change it to SS2005
> in the Options menu.
> Good luck :-)
> "Win" wrote:
>
...or look up *sp_dbcmptlevel* in Books On Line.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--010605060902050401060003
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Skaale wrote:
<blockquote cite="midD4FD891D-6162-4A89-9CA5-3E86EADE0223@.microsoft.com"
type="cite">
<pre wrap="">Yes, but be aware that it will be in SS2000 compatibility level. If you want
to use SS2005 features in the database you will have to change it to SS2005
in the Options menu.
Good luck :-)
"Win" wrote:
</pre>
</blockquote>
...or look up <b>sp_dbcmptlevel</b> in Books On Line.<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</body>
</html>
--010605060902050401060003--

No comments:

Post a Comment