I couldn't access the Secondary Database after I finished Shipping Configuration

Dear All

Please I need an urgent help

After i finished all Transaction Log Shipping Configuration.

I tried to use the database in the secondary database but i couldn't access it

i saw it in SQL Managment Studio as (Restoring......)

i tired to make a database snapshot from it , i had a message

Msg 1822, Level 16, State 1, Line 1

The database must be online to have a database snapshot.

Please urgently

the secondary database is in a "Restoring" mode in this case, so you cannot take a snapshot of it. this is by-design.

if you do want take snapshot of the secondary database , you can choose the "standby"
mode when you configure the logshipping secondary db.

HTH.

thanks

Yunwen

Hw to get Schema file through DTS

Hi,
Cud anybody tell me how to get schema as a DTS file?
Its urgent.
Thanks,
Dutt.Have a look at the script and ScriptTransfer methods in SQLDMO. Also have a
look at 3rd-party tools eg RedGate's SQL Compare.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com