Wednesday, March 7, 2012

Restore a single table

I have online and offline backup of my SQL Server 2000 databases.
I want to restore a single table from this backups .
I cant restore as my full db with a new name because I dont have enough room
for it.
What's your offers?
Hi
Since it was a SQL Server 6.5 feature , you cannot restore a single table in
SQL Server 7/2000
Do you have another server to restore the database?
"Banu_tr" <abuslu@.hotmail.com> wrote in message
news:4C761E38-1E6A-421A-A782-C66D07B3E2AE@.microsoft.com...
> I have online and offline backup of my SQL Server 2000 databases.
> I want to restore a single table from this backups .
> I cant restore as my full db with a new name because I dont have enough
room
> for it.
> What's your offers?
|||SQL Server 2000 don't have a feature that allows you to restore a single
table.
Stephen Jiang
Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Banu_tr" <abuslu@.hotmail.com> wrote in message
news:4C761E38-1E6A-421A-A782-C66D07B3E2AE@.microsoft.com...
> I have online and offline backup of my SQL Server 2000 databases.
> I want to restore a single table from this backups .
> I cant restore as my full db with a new name because I dont have enough
room
> for it.
> What's your offers?

No comments:

Post a Comment