Hi Catch,

Thank you for your suggestion

Next time i will follow you before posting the question.

Thanks

Hi Experts,

can you and body please explaine what is the differences in the below to commands

EXEC sp_spaceused @updateusage = N'TRUE';

EXEC sp_spaceused

i am using in test database i am...

Hi Gail,

As per your comments i will try to restore the log bacup and we had taken full backup also but no use please suggest me

But some body says we...

Can you restore a damage page using below script...

RESTORE DATABASE dbccpagetest PAGE = '58' FROM DISK = 'C:\dbccpagetest.bak';

after that restore your database..

-- Need to complete roll forward. Backup the log...

Hi John,

sorry my reply i dont have any idea about SQL AGENT .out please help me on this ... i need learn it.

What is SQLAGENT.OUT where can we find.

My answer...

hi

we cant take differential backups we have only take every day 12:00 AM full backup and every 15 teen mins T-log backups.

Tx

Hi Team,

ERROR LOG :

Service Broker is disabled in MSDB or MSDB failed to start. Server level event notifications can not be delivered. Event notifications with FAN_IN in other databases could...

Hi Gail,

I have given Error log information could you please check and update in the post entire day i am working in this but still im facing prob

in my...

in errorlog it shows below error

Service Broker is disabled in MSDB or MSDB failed to start. Server level event notifications can not be delivered. Event notifications with FAN_IN in...

Hi Team,

I have follow below steps

Detach the damaged msdb. You can't just detach msdb because you're not allowed to detach system databases. However, you...

Hi Gail,

I dont have backup what should i do suggest me please help

Hi Gail,

RESTORE DATABASE MSDB

FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\NewData\msdbdata.mdf'

WITH FILE=1,

NORECOVERY;

Msg 3241, Level 16, State 0, Line 1

The media family on...

Hi Gail,

SOrry my font. size 7 i dont know

the datapath is available in below path

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

using restore comman only i have to restore right

suggest any boyd properway..

this...

where can i check windows event logs

can you suggest me path...

i think event viewer is windows event logs right can you correct me.

Hi Guys

Thank you very much for your spontinious reply..

Really appriciated.

Tx