Thanks a lot Chiranjib Saha Roy for helping me complete this automation.

This was one of the key information I felt a DBA should have to start with on working with Sharepoint Metadata.

We can start looking into the database taking most of the memory and then looking into the indexes taking most of the memory using sys.dm_os_buffer_descriptors . This will help drill...

Hi Shaun,

I tried it out myself this morning to check if the restore entry goes in backupset table but could not succeed in that. I have been using backupset for...

Will definitely put this information into action the next time.

@Lance Reger.. The thing is that the tempdb is created every time the SQL Server restarts taking the database template from tempdb. But if the location is not present then...

Thankyou All for the comments and views.

@ Perry Whittle . I just ment to move the files physically and not syntactically.

@ Grasshopper. I don not think that will be...

sqlservr.exe -f worked for me.

I really appreciate the comments and arguments.

cdiebolt.. The language of the question is tricky. The intention was to ask about the performance of the server affected. However the size...

I really appreciate the comments and arguments.

@cdiebolt.. The language of the question is tricky. The intention was to ask about the performance of the server affected. However...

I really appreciate the comments and arguments.

@cdiebolt.. The language of the question is tricky. The intention was to ask about the performance of the server affected. However...

I appreciate all the comments and discussion.

@cdiebolt .. The question was a bit tricky with the language. However the backup/restore operations are not affected as per the...

@ziangij

please try the code below. I think this is what the auhtor wanted to convey. However one thing I would like to point out that Datetime is...

Very good question.. I missed my points but learnt something new today.. 😀