log shipping .trn files question

[Jason Huang]

Hi,

I've established the log shipping between my Primary database server and the
Stand by database server.
In the Stand by server, the database is gray, and in the BACKUP folder,
there're MyDB_init.bak and many .TRN files.

1.How do I make the MyDB's color not gray in that Stand by server? I wanna
test the SELECT and see if the record between the Primary and Stand by
server are consistant.

2. What will happen if I delete some .TRN files?

Thanks for help.


Jason

 

[Mark Rae [MVP]]

Thanks for help.

What did they say in the SQL Server forum(s)...?