sys.databases returned 'RECOVERING'.

No other files exists in that drive other than the two log files of this database. The 2 files take 599GB space.

Thanks Gail,

In SQL error log it is showing recovering and it took 19 minutes to move from 89% to 90%.

All log files are in D drive and have only 8MB...

Thanks Gail..

Thanks SQLisAwe5oMe

Thanks happycat59..this was the kind of advise i was looking..

Thanks a lot

Thanks Perry for sharing the knowledge.

Read-intent is not a Primary role option. The only options for the primary role are

allow all connections, does what it says all connections are allowed

allow...

Thanks Perry.

The server where i...

Thanks Perry ..That helped

Thanks a lot Perry..

DB is in full recovery mode and its the Primary of an...

John Mitchell-245523 (8/18/2014)

---

Look at the properties of the connection manager DestinationSCODatabase. What is the name of the server? What authentication mode does it use? If it uses...

Yes

Thanks twin.devil.

Both the databases are in same server.

Strange thing is that the same run without any issue in a default instance and have issue with named instance.

Thanks for the reply..

The job is run under SA account.

config file is using windows authentication only.