Thanks for the Reply ninja.

Its teh same query executing morning and afternoon

kumar.sachu08 (8/11/2011)

---

Hi,

I need help to planning for create best database architecture in sql 2008.

My Cafeteria's are :

Suppose we are planning to create such type of database in which more than...

Bulk Logged Recovery model also supports point in time recovery ,provided the log file doent have a bulk operation.

Thanks Gail :w00t:

Thanks a ton Gail..

So you mean to say i cannot find the lost records straight,only if i create a fresh DB and restore till tail log and then do a...

Thanks a lot Gail.

Is there anyway I can save the data?

What all i can do to prevent the data loss???

How can i found the lost records after doing the repair?

The...

Hi Gail,

Thanks for the reply . Please find the results below.Strange part is am not able to find the object with id:2560

Msg 8909, Level 16, State 1, Line 1

Table error:...

The best way to control the log file growth is to have periodic transaction log backup.

Run checkdb on subscriber and got below errors

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 2560, index ID 2048, page ID (3:3465696). The PageId in the page...

We use SQL Litespeed for backup and restore.

Language Event 0 use [master] RESTORE database [db1] FROM VIRTUAL_DEVICE='VDI_D8B0897D-3BBC-412F-B7F3-AF854B8906C6_0', VIRTUAL_DEVICE='VDI_D8B0897D-3BBC-412F-B7F3-AF854B8906C6_1', VIRTUAL_DEVICE='VDI_D8B0897D-3BBC-412F-B7F3-AF854B8906C6_2' with blocksize=65536, maxtransfersize=1048576, buffercount=20, STATS = 10, MOVE N'db1'...

We restored the DB to different server and it created a duplicate file for one .ndf file.

We tried our best but not able to delete that file.

Do i need...

GilaMonster (7/27/2011)

---

Restore from a clean backup, that can't be repaired.

Additionally, this doesn't just happen. Something's damaged the data file. I suggest you run some hardware diagnostics, something's written garbage over...

Thanks Everyone.

Tried to restore from a clean backup and now its shwoing duplicate files and not allowing to delete the unneccesary file at all.

Tried deleteing the file making the DB...

NOw we are received below error after many foreign key violation.

Error messages:

•The process could not bulk copy into table '"dbo"."Master"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)

Get help: http://help/MSSQL_REPL20037

•Batch send failed

•Violation of...