In event logs before DB went offline I can see "Certificate Services clinet has been started succeffully" and than next log says "Services Stopped successfully" and I found thats data...

Thanks sanket for prompt reply..

Can you guide me where to check the auto close option. Bcos DB is offline and so I am not able to see its properties.. Is...

Guys got it.. !

i restored database who was in restoring mode.. and than try my backup job manually and it works..!

for restoration I used below command;

Restore Database <Databasename> with Recovery;

thanks...

One thing that I found it Namedpipes disabled.. ! Is it affecting connection ? is it due to namedpipes backup job failing ?

Correct me if I m wrong

Thanks a lot Anthony..!

I am agree with you Anthony, that shrinking is not best practice. But here I am eager to know that how did my senior was able to shrink log file...

Thanks master for your reply,

Before i shrink some data files as well as log file of other databases. After shrinking there no bad effect on other db. I am shrinking...

So If we have not taken full backup, than differential backup will work ? Is it just check with MSDB file and run ? Please clear my doubt...

I think its not possible... but can you pls share the screen shot of successful backup OR can you gimme the logs of the same successful backup ?

Hi Gilamonster,

I lower down the max memory allocation but still no effect. Has I need to restart the services ? Or any other solution?

My Sql server 2005 is on Windows...

Thanks a lot Gilamonster,

the size of the normal page is 8 KB, what is be the size of LOB pages ? Is it chain of normal pages ?

and my second...

Is shrinking of data file, or log file can affect performance ?

Hello there,

The best practice to learn MSSQL is to practice on test machine while reading. Only reading will enhance your theory knowledge but as DBA you must be practical. As...

Got it dude... My full backup took some more time to execute and at the same time my differential backup started and thus (I think) due to overlapping of two...

yes , Full backup taken.