Is this not possible to do?You cannot take a backup on sql2k5 and restore it to sql2k instance. The metadata has changed significantly in sql2k5 for sql2k to understand.
Showing posts with label attempt. Show all posts
Showing posts with label attempt. Show all posts
Wednesday, March 7, 2012
restore a sql server 2005 x64 db backup to sql server 2000 32-bit
When I attempt to restore a db backup from sql server 2005 x64 on my production server to a laptop that has sql server 2000 32-bit, I get a message like "Too many files". And when I go to the tab that let's you change the paths to the db files, the two path fields are blank, when normally they would show some paths.
Tuesday, February 21, 2012
Restore
Hi,
I'm relatively new to SQL, but learning fast, and am having a problem
restoring a database on SQL 2000.
When I attempt to restore the database I get an error "Cannot find file ID 2
on device 'D:\name.bck" The company that created the database say that they
can restore it without problem.
I tried following the advice in
http://webservertalk.com/showthread.php?threadid=476716 - the database checks
out as a valid backup set when using the verifyonly command in QA, but when
I completed step 5 Enterprise manager showed the DB as "Loading" but did not
actually load - I left it for approx 10 mins in this state before cancelling
and restoring from an older backup, which worked without problem. The
database is only 50mb and normally restores in seconds.
Can anyone help?
Thanks
Tim
Actually, I have managed to fix this by deleting the existing database and
restoring the new one.
Tim
"Timmy" <Tim@.tim.tim> wrote in message
news:eD2Q2Mu5FHA.3984@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm relatively new to SQL, but learning fast, and am having a problem
> restoring a database on SQL 2000.
> When I attempt to restore the database I get an error "Cannot find file ID
> 2 on device 'D:\name.bck" The company that created the database say that
> they can restore it without problem.
> I tried following the advice in
> http://webservertalk.com/showthread.php?threadid=476716 - the database checks
> out as a valid backup set when using the verifyonly command in QA, but
> when I completed step 5 Enterprise manager showed the DB as "Loading" but
> did not actually load - I left it for approx 10 mins in this state before
> cancelling and restoring from an older backup, which worked without
> problem. The database is only 50mb and normally restores in seconds.
>
> Can anyone help?
> Thanks
> Tim
>
I'm relatively new to SQL, but learning fast, and am having a problem
restoring a database on SQL 2000.
When I attempt to restore the database I get an error "Cannot find file ID 2
on device 'D:\name.bck" The company that created the database say that they
can restore it without problem.
I tried following the advice in
http://webservertalk.com/showthread.php?threadid=476716 - the database checks
out as a valid backup set when using the verifyonly command in QA, but when
I completed step 5 Enterprise manager showed the DB as "Loading" but did not
actually load - I left it for approx 10 mins in this state before cancelling
and restoring from an older backup, which worked without problem. The
database is only 50mb and normally restores in seconds.
Can anyone help?
Thanks
Tim
Actually, I have managed to fix this by deleting the existing database and
restoring the new one.
Tim
"Timmy" <Tim@.tim.tim> wrote in message
news:eD2Q2Mu5FHA.3984@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm relatively new to SQL, but learning fast, and am having a problem
> restoring a database on SQL 2000.
> When I attempt to restore the database I get an error "Cannot find file ID
> 2 on device 'D:\name.bck" The company that created the database say that
> they can restore it without problem.
> I tried following the advice in
> http://webservertalk.com/showthread.php?threadid=476716 - the database checks
> out as a valid backup set when using the verifyonly command in QA, but
> when I completed step 5 Enterprise manager showed the DB as "Loading" but
> did not actually load - I left it for approx 10 mins in this state before
> cancelling and restoring from an older backup, which worked without
> problem. The database is only 50mb and normally restores in seconds.
>
> Can anyone help?
> Thanks
> Tim
>
Restore
Hi,
I'm relatively new to SQL, but learning fast, and am having a problem
restoring a database on SQL 2000.
When I attempt to restore the database I get an error "Cannot find file ID 2
on device 'D:\name.bck" The company that created the database say that they
can restore it without problem.
I tried following the advice in
http://dbforums.com/showthread.php?threadid=476716 - the database checks
out as a valid backup set when using the verifyonly command in QA, but when
I completed step 5 Enterprise manager showed the DB as "Loading" but did not
actually load - I left it for approx 10 mins in this state before cancelling
and restoring from an older backup, which worked without problem. The
database is only 50mb and normally restores in seconds.
Can anyone help?
Thanks
TimActually, I have managed to fix this by deleting the existing database and
restoring the new one.
Tim
"Timmy" <Tim@.tim.tim> wrote in message
news:eD2Q2Mu5FHA.3984@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm relatively new to SQL, but learning fast, and am having a problem
> restoring a database on SQL 2000.
> When I attempt to restore the database I get an error "Cannot find file ID
> 2 on device 'D:\name.bck" The company that created the database say that
> they can restore it without problem.
> I tried following the advice in
> http://dbforums.com/showthread.php?threadid=476716 - the database checks
> out as a valid backup set when using the verifyonly command in QA, but
> when I completed step 5 Enterprise manager showed the DB as "Loading" but
> did not actually load - I left it for approx 10 mins in this state before
> cancelling and restoring from an older backup, which worked without
> problem. The database is only 50mb and normally restores in seconds.
>
> Can anyone help?
> Thanks
> Tim
>
I'm relatively new to SQL, but learning fast, and am having a problem
restoring a database on SQL 2000.
When I attempt to restore the database I get an error "Cannot find file ID 2
on device 'D:\name.bck" The company that created the database say that they
can restore it without problem.
I tried following the advice in
http://dbforums.com/showthread.php?threadid=476716 - the database checks
out as a valid backup set when using the verifyonly command in QA, but when
I completed step 5 Enterprise manager showed the DB as "Loading" but did not
actually load - I left it for approx 10 mins in this state before cancelling
and restoring from an older backup, which worked without problem. The
database is only 50mb and normally restores in seconds.
Can anyone help?
Thanks
TimActually, I have managed to fix this by deleting the existing database and
restoring the new one.
Tim
"Timmy" <Tim@.tim.tim> wrote in message
news:eD2Q2Mu5FHA.3984@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm relatively new to SQL, but learning fast, and am having a problem
> restoring a database on SQL 2000.
> When I attempt to restore the database I get an error "Cannot find file ID
> 2 on device 'D:\name.bck" The company that created the database say that
> they can restore it without problem.
> I tried following the advice in
> http://dbforums.com/showthread.php?threadid=476716 - the database checks
> out as a valid backup set when using the verifyonly command in QA, but
> when I completed step 5 Enterprise manager showed the DB as "Loading" but
> did not actually load - I left it for approx 10 mins in this state before
> cancelling and restoring from an older backup, which worked without
> problem. The database is only 50mb and normally restores in seconds.
>
> Can anyone help?
> Thanks
> Tim
>
Subscribe to:
Posts (Atom)