In SQL there is no such thing like Incremental Backup ,but have that in Oracle in which...

Any help on this Please

Thanks Gail,

Anyway we can get the changed or modified data from that file??

Can you post the code you used here?

Its set to master only.

Try this

SELECT o.[name] object_name, o.[type], i.[name] index_name, i.[index_id], f.[name]

FROM sys.indexes i

INNER JOIN sys.filegroups f

ON i.data_space_id = f.data_space_id

INNER JOIN sys.all_objects o

ON i.[object_id] = o.[object_id]

WHERE i.data_space_id = f.data_space_id

AND o.type = 'U' --...

if you take t logs other than LS its definitely going to break your log backup chain

Thanks Steve...I am really really sorry..what i wanted to type to CHECKDB??

How can i edit the heading of the post?

Simple Recovery

We have requested infrastructure team for that..

Is there any other way to handle this.

Thanks Again Gail.. You are my Guru..

Only mdf and ldf files of that particular db exists in that drive.

Thanks a lot Gail.

S:\LOG\ABC_Log_508.ldf: Operating system error 112(There is not enough space on the disk.) encountered.

To allow recovery to succeed, the log file 'ABC_log5' has been expanded beyond its maximum...

Grant Fritchey (7/8/2014)

---

While I'm not a fan of GUIDs as clustered keys, I've seen it in a production system and it wasn't the end of the world. We did have...

Thanks Grant for the reply.

Yes there exists foreign key between table Muthal and ConsumableType.

Thanks Sean,

The table name is put just for name sake and will be changed.

CreatedBy

ModifiedBy are referring to other tables where they are PKEY and data type GUID.

Do i...