Hi All,

I have the same issue.

Can any suggest how to resolve this issue.

Agent is not running.

The sparse file size is around 60GB when snapshot is going to Suspended state. I have 600 GB free space in disk . and auto growth is 100 MB...

Database size is 300 GB

Having 2 datafiles each about 120 GB

Msg 156, Level 15, State 1, Line 3

Incorrect syntax near the keyword 'WHERE'.

Hi

I am unable to fetch data using that query is that the complete query or do i need to do any changes in it.

i couldn't see any select...

WRITE Log is occurring through out the normal operation of application.

In my environment .mdf files are in one drive and .ldf files are in another drive. we had tranactional replication in the instance where i am getting the performance issue.

Log file is used in sequentially . Unless first log is completely filled .Tranactions wont go to another log which is in other disk. so ho come it brings...

Its not heap.

They are clustered and non clustered indexes.

there is no shrink operation after rebuild.

DBCC check db came clear for these databases.

The issue is TDP backups are not happening through agent.

The database in which this error is through is in mirroring.

I am not aware how to troubleshoot it.

Can any one give some point here i need to start debugging

I created second ldf file with initial size as 2 mb and filegrowth option is set as unrestricted to both ldf files. when i saw after some time the...

Thanks for clarifying.. its a great help for me..

i tried using restore command in SSMS for the same issue and it went fine and the database restored successfully. the issue is with GUI and how...

the database 'test' is not there in the instance how can i specify the database id