Posted by Erland Sommarskog on 06/16/05 01:15

Steve Kuekes (skuekes123@mail.com) writes:
> I have two sql servers, I have defined each one as a linked server to
> the other. I can mostly access the servers from one another, but I get
> the following error on a sql insert.
>
> Insert statement...
>
> INSERT INTO [U1STSV02].[Custom Log Shipping].dbo.ls_secondary_files
> (database_name, tl_file_name, tl_applied, lsplanid, lssecid,
> compression_type) VALUES ('javaweb', 'c:', 'N', 1, 1, 0)
>
> i get an error message
>
> Server: Msg 913, Level 16, State 8, Line 1
> Could not find database ID 10. Database may not be activated yet or may
> be in transition.

Hm, what happens if you rename database to CustomLogShipping? I seem
to recall that there have been issues with names that needs quoting
because of special characters.

If you do a SELECT * FROM master..sysdatabases on the target server,
do you see any database with db_id = 10? Which id does [Custom Log
Shipping] have?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]