thanks for writing the below query..

Seems after executing the provided query,if I query the DM: sys.dm_os_buffer_descriptors I can get the database_id.

Is it?

select top 10 * from sys.dm_os_buffer_descriptors

Regards

Sourav

How to confirm that the database_id of the resource db is 37267?

Select Serverproperty('ResourceVersion') => Tells about the version of the "resource db"..

Any query explicitly can be fired to get the...

Thanks Gail..It works now.I verified the same. 😛

Just before running the dbcc checkdb statement I had to take it in single_user mode.

Have a great day to you!

Regards

Sourav

dbcc checkdb

DBCC results for 'sys.filestream_tombstone_2073058421'.

There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".

DBCC results for 'sys.syscommittab'.

There are 0 rows in 0 pages for object "sys.syscommittab".

CHECKDB found 0 allocation errors...

yes,

1. I created the new db as follows::

CREATE DATABASE abc1

ON (NAME = abc_dat,

FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\abc1.mdf',

SIZE = 10,

MAXSIZE =...

Hello Pardeep

I performed the following steps:

1. detached the db.

2. executed the below query to create a new db considering the earlier available .mdf file(abc.mdf), but mentioned a new .ldf file...

Thanks Pradeep...I forgot the command..:-)

By the way, I was in a mood to do some R&d. So deleted the .LDF from one of the database. (@home system..Chill!!).

Now unable to do...

Hello Abhay and others

Thanks for putting up your expert comments.

Could you please clarify the below concern?

If the .LDF is gone, what are the steps required to follow to recover the...

Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=913593422,referenced_minor_id=1) of row (class=0,object_id=1617595930,column_id=0,referenced_major_id=913593422,referenced

Execute the below 2 queries to look for the objects involved in this regard:

SELECT Object_Name(913593422)

SELECT Object_Name(1617595930)

Regards

Sourav

Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'color=#red'.

Msg 8992, Level 16, State 1, Line 1

Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=913593422,referenced_minor_id=1) of row (class=0,object_id=1713596272,column_id=0,referenced_major_id=913593422,referenced_minor_id=

1)...

Dude,

Try this::

ALTER DATABASE [sourav] SET single_USER WITH NO_WAIT

DBCC CHECKDB ('sourav',REPAIR_ALLOW_DATA_LOSS)

This might help you to repair your DB after allowing some data loss.

Regards

Sourav

Run the below query::

DBCC CHECKDB('db') WITH No_INFOMSGS, ALL_ERRORMSGS[/b]

And post the output!

Regards

Sourav

Can you stop the SQL Server and after sometime try to execute the same to see the outcome?

Thanks for providing the links. Quite useful.

However, What did I find from the link-1 is: it is a complete analysis by running profiler which might take couple of days...

Thanks for all your response.

Can you please suggest me further and let me know if the server having 2 "Clustered Nodes",whether the steps will be same?

Shall I first start with...