OK, since that was not know. I'd thought in the lines of overall server /...

I guess it is not possible to hide the Linked servers.

I tried creating a sql login as a db_owner for couple of databases and when logged in as...

I second Steve's thoughts on separate storage for Tempdb/Data/Log.

Backup compression setting (by default is not set to compress the backups)

Though these are not server level configurations, considering that it is...

What do you see in the execution plan?

Hi Lavanyasri,

Thanks for sharing the links, but I doubt how much the OP would be really in need of the links now (after 8 days), by which time the problem...

You are welcome...

Yes Jason, I did not look at the column GroupName that OP requested.. Thanks for pointing that out..

Just like how you saw this thread as an active / recent post, I too saw the post and gave...

Hi,

As I guessed the secondary database is not in norecovery mode. There must have been a recovery done by mistake in your previous steps. I...

Have you tried from BIDS?

Create a new SSIS project in BIDS, under packages, right click add existing package and choose the SQL Server where it is stored..

Give it a...

No problem Jimmy..

I second Gail's thoughts..

Object explorer is the pane in left hand side of the SQL Server...

Well, the largest table that I set up at my end is almost 80 % of the size that you have mentioned...

Your understanding on the locks being placed on the...

baabhu (12/15/2011)

---

The errors are pretty clear. The restored database is not in recoverymode/standby mode.

Can you confirm the following

1) Your primary db (Source db) is in the full recovery...

Are you sure the secondary db is in norecovery mode? the error information indicates that it is not in norecovery mode. Can you take a screenshot of the database in...