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