Error: Table name must be specified in the format owner_name.table_nameoftable dbo.corp not found (4235523)

User owned table with domain notation, unable to be recovered. (eg: domainname\owner.TABLENAME)

Any other table in database owned by dbo can be recovered. Any attempt to recover table or view data results in -

WORKAROUND:

exec master..xp_objectrecovery

, @FileName='D:\Backup\Northwind201111010555_Full.BKP'

, @ObjectName='dbo.Customers'

, @DestinationServer='ALV999999\instance_name'

, @DestinationDatabase='database_name'

, @DestinationTable='Customers_temp'

, @TempDirectory='D:\Backup'

Status:



Waiting for fix in a future release of LiteSpeed.

You should delimit your table name.

This is not a bug. OLR requires that objects be properly delimited.

Similar behavior is enforced by Sql Server.

"select * from corp\19111.ADDR" Will fail natively in Sql Server but "select * from [corp\19111].ADDR" Will succeed (since it is properly delimited)
SEE:
http://msdn.microsoft.com/en-us/library/ms176027(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/aa224033(v=sql.80).aspx