IMporting sql2000 backup database ?

Dear all,
I have an database backup from SQL server2000.
How can I import it inside SQL server 2005 ?
regards
serge
serge calderara wrote:
> Dear all,
> I have an database backup from SQL server2000.
> How can I import it inside SQL server 2005 ?
> regards
> serge
Use the RESTORE DATABASE command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||here is how I am proceedig.
First I have creat a new database named NOMOS, same as my old backup. Only
system tables are created here as I want to restore the whol configuration
from my backup.
Then I select the Restore backup from management studio and select my new
created database NOMOS as the destination and my backup file as a source
Then I get error message :
"The backup sets hold a backup of a database other than the existing 'NOMOS'
database"
Which is not treu casue I just made the backup of that databased before
installing 2005 ?
thnaks for comments
regards
serge
"Tracy McKibben" wrote:

> serge calderara wrote:
> Use the RESTORE DATABASE command...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
|||Sorry I find it out...
I forgot to set the overwrite option
:-)
"Tracy McKibben" wrote:

> serge calderara wrote:
> Use the RESTORE DATABASE command...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

IMporting sql2000 backup database ?

Dear all,
I have an database backup from SQL server2000.
How can I import it inside SQL server 2005 ?
regards
sergeserge calderara wrote:
> Dear all,
> I have an database backup from SQL server2000.
> How can I import it inside SQL server 2005 ?
> regards
> serge
Use the RESTORE DATABASE command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||here is how I am proceedig.
First I have creat a new database named NOMOS, same as my old backup. Only
system tables are created here as I want to restore the whol configuration
from my backup.
Then I select the Restore backup from management studio and select my new
created database NOMOS as the destination and my backup file as a source
Then I get error message :
"The backup sets hold a backup of a database other than the existing 'NOMOS'
database"
Which is not treu casue I just made the backup of that databased before
installing 2005 '
thnaks for comments
regards
serge
"Tracy McKibben" wrote:

> serge calderara wrote:
> Use the RESTORE DATABASE command...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Sorry I find it out...
I forgot to set the overwrite option
:-)
"Tracy McKibben" wrote:

> serge calderara wrote:
> Use the RESTORE DATABASE command...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

IMporting sql2000 backup database ?

Dear all,
I have an database backup from SQL server2000.
How can I import it inside SQL server 2005 ?
regards
sergeserge calderara wrote:
> Dear all,
> I have an database backup from SQL server2000.
> How can I import it inside SQL server 2005 ?
> regards
> serge
Use the RESTORE DATABASE command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||here is how I am proceedig.
First I have creat a new database named NOMOS, same as my old backup. Only
system tables are created here as I want to restore the whol configuration
from my backup.
Then I select the Restore backup from management studio and select my new
created database NOMOS as the destination and my backup file as a source
Then I get error message :
"The backup sets hold a backup of a database other than the existing 'NOMOS'
database"
Which is not treu casue I just made the backup of that databased before
installing 2005 '
thnaks for comments
regards
serge
"Tracy McKibben" wrote:
> serge calderara wrote:
> > Dear all,
> >
> > I have an database backup from SQL server2000.
> > How can I import it inside SQL server 2005 ?
> >
> > regards
> > serge
> Use the RESTORE DATABASE command...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Sorry I find it out...
I forgot to set the overwrite option
:-)
"Tracy McKibben" wrote:
> serge calderara wrote:
> > Dear all,
> >
> > I have an database backup from SQL server2000.
> > How can I import it inside SQL server 2005 ?
> >
> > regards
> > serge
> Use the RESTORE DATABASE command...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Importing DB backup file to SQL Server 2005

Hi all,

I'm using shared sql space on a new provider and am trying to import a database backup file - of the format filename.db.

I cannot figure out how to import this file type using the 2005 express tools - I can connect to the database and create and drop tables alright, but I cannot just import the existing database.

I really haven't got the time on my connection to download the fully blown SQL server trail to be able to do this, so can anyone help me out with any easier solutions?

Cheers, Mike

If it is a SQL backup file, then use RESTORE. Check in Books Online about RESTORE -especially the WITH MOVE option.

Importing DB backup file to SQL Server 2005

Hi all,

I'm using shared sql space on a new provider and am trying to import a database backup file - of the format filename.db.

I cannot figure out how to import this file type using the 2005 express tools - I can connect to the database and create and drop tables alright, but I cannot just import the existing database.

I really haven't got the time on my connection to download the fully blown SQL server trail to be able to do this, so can anyone help me out with any easier solutions?

Cheers, Mike

If it is a SQL backup file, then use RESTORE. Check in Books Online about RESTORE -especially the WITH MOVE option.

Importing Database

I have SQL Server 7.0 and I am going to update to SQL Server 2000, Can I import the database? Can I make a backup from SQL Server 7.0 and then to restore with SQL Server 2000. (I have tape backup).
Thanks and Best Regards,
hi jose,
yes, you can restored backup file of SQL 7 database to SQL Server 2000. SQL 2000 will upgrade
the SQL 7 database during the restore process. Once restore process is over run update
statistics on all tables, ideally WITH FULLSCAN.
Vishal Parkar
vgparkar@.yahoo.co.in
|||Please refer to these links that will provide you all the information that
you would possibly need to perform the upgrade:
How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000
http://www.microsoft.com/technet/pro...y/sqlugrd.mspx
Upgrading from SQL 7 to SQL 2000
http://msdn.microsoft.com/library/de...us/instsql/in_
upgrade_5jw3.asp
This link will give you all about SQL installation
http://msdn.microsoft.com/library/de...us/howtosql/ht
_install_5vsj.asp
FAQs to know before you plan the upgrade
http://support.microsoft.com/default...b;en-us;261334
Hope this helps.
Sanchan [MSFT]
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Importing Database

I have SQL Server 7.0 and I am going to update to SQL Server 2000, Can I imp
ort the database? Can I make a backup from SQL Server 7.0 and then to restor
e with SQL Server 2000. (I have tape backup).
Thanks and Best Regards,hi jose,
yes, you can restored backup file of SQL 7 database to SQL Server 2000. SQL
2000 will upgrade
the SQL 7 database during the restore process. Once restore process is over
run update
statistics on all tables, ideally WITH FULLSCAN.
Vishal Parkar
vgparkar@.yahoo.co.in|||Please refer to these links that will provide you all the information that
you would possibly need to perform the upgrade:
How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000
http://www.microsoft.com/technet/pr...oy/sqlugrd.mspx
Upgrading from SQL 7 to SQL 2000
http://msdn.microsoft.com/library/d...-us/instsql/in_
upgrade_5jw3.asp
This link will give you all about SQL installation
http://msdn.microsoft.com/library/d...-us/howtosql/ht
_install_5vsj.asp
FAQs to know before you plan the upgrade
http://support.microsoft.com/defaul...kb;en-us;261334
Hope this helps.
Sanchan [MSFT]
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Importing a SQL Server 2005 database into SQL Server 2000

Hi there,

Just wanted to ask is it possible to 'restore' a SQL Server 2005 backup file into SQL Server 2000.

What I mean is that we are being supplied with a SQL Server 2005 backup file, but we currently use 2000? Can we use this or do we need to upgrade etc?

Thanks.

Simon Jefferies

Ho, you can′t use that. You will have to do an export of the database from SQL Server 2005 and import the exported content inot the database. If you have a direct connection between the two instance you can use any export / import wizard (like dts) for the work.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||by using import/export wiz we can only import/export tables & views, what about other objects like SP, triggers, user functions etc?

Importing a SQL Server 2005 database into SQL Server 2000

Hi there,

Just wanted to ask is it possible to 'restore' a SQL Server 2005 backup file into SQL Server 2000.

What I mean is that we are being supplied with a SQL Server 2005 backup file, but we currently use 2000? Can we use this or do we need to upgrade etc?

Thanks.

Simon Jefferies

Ho, you can′t use that. You will have to do an export of the database from SQL Server 2005 and import the exported content inot the database. If you have a direct connection between the two instance you can use any export / import wizard (like dts) for the work.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||by using import/export wiz we can only import/export tables & views, what about other objects like SP, triggers, user functions etc?