Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Create database using Backup file Expand / Collapse
Author
Message
Posted Tuesday, March 17, 2009 6:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:34 AM
Points: 6,166, Visits: 13,309
Venki

you didnt indicate in your first post that the backup was a sql2005 database going into sql2000. This cannot be done. Only option is to DTS the data across to a sql2000 structure database


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #677364
Posted Tuesday, March 17, 2009 6:54 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
You can never downgrade your database. it is not possible to restore a 2005 backupfile onto a 2000 server, same thing with the 2005 and 2008.


Post #677387
Posted Tuesday, March 17, 2009 8:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:16 PM
Points: 146, Visits: 459
Adiga (3/17/2009)
You cannot restore a SQL Server 2005 database backup to SQL Server 2000.



Pradeep Thanks again for your clarifications.

Is it possible to transfer the database directly from 2005 server to 2000 server?

How can I use the database? In the mean time I ask my admin team to upgrade the my development Server to 2005.


Thanks a lot,
Venki
Post #677473
Posted Tuesday, March 17, 2009 8:14 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
[b]

Is it possible to transfer the database directly from 2005 server to 2000 server?



No, not through backup and restore method, instead you can script out your 2005 database and then run it against your 2000 server.


Post #677482
Posted Tuesday, March 17, 2009 8:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:16 PM
Points: 146, Visits: 459
Sorry,
I haven't seen the next page.

Yes, you are right, it is my mistake, not to tell the back up file is from 2005. But I thought this versioning won't be a problem for restoration.

So I can create tables manually and do the DTS from 2005 db to 2000 db.




Thanks a lot,
Venki
Post #677483
Posted Tuesday, March 17, 2009 8:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
Yes, you can do it either way


Post #677488
Posted Tuesday, March 17, 2009 8:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:16 PM
Points: 146, Visits: 459
Krishna (3/17/2009)

No, not through backup and restore method, instead you can script out your 2005 database and then run it against your 2000 server.



Thanks a lot Krishna.
I am thinking to do the same. and also I will ask my admin team to upgrade my dev sql server to 2005. This is better and if it is not possible will do what you told.


Thanks a lot,
Venki
Post #677490
Posted Tuesday, March 17, 2009 8:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
No problem at all.


Post #677492
Posted Wednesday, July 8, 2009 5:18 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 4:46 PM
Points: 58, Visits: 316
a
Post #749763
Posted Wednesday, July 8, 2009 5:19 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 4:46 PM
Points: 58, Visits: 316

Can
Post #749764
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse