I got the same error ... Restart worked but it just an temporary solution .. I got the same error again after a while... Do I need install the SQL...

Thanks Sir!!:-)

Thanks Bob.Appreciate your reply.

I will recycle the errorlog every week and also I maintain only the last six error logs. It will not workout for me. :w00t:

Any other...

No one???!!

Hi Raghavender.

This link will help you :

You can get some info about Checkpoint , Lazywriter and Write Ahead Logging as well.

Hi Mohammed ,

Please find the details..even in sys.master_files the filenames are same...

master1C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdfPRIMARY4096 KBUnlimited10%data only

mastlog2C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldfNULL1280 KBUnlimited10%log only

I have used both.. Error remains the same.

I have configured for more than 3 Secondary DB's in Log Shipping. 2 is not the maximum.;-)

Version store is where the row versions (created for snapshot isolation) are stored.

Could you elaborate on thie please ?

Thanks for the reply!!

I need the diffence between row versioning in Snaphot isolation(not data type) and version store?

I dont think so.... There will be a limit!!

Congrats!!!!!:-)

Hi ,

Thanks for your reply.

Restore job will be having only one step . And the error I got is "Message

Executed as user: Ramco\_saran. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The...

Any update on this plz???

Hi Gaurav ,

Approx. how many procedures you will have which is dependent on that table???