I am an accidental DBA as well but I have been investigating the topic for a little while. Lets stick to simplictity and you can improve at a later...

They mentioned on the webinar number 18 (See Training Section - Previous Webinars) that performing test restores also gives you the practise at the task as well as verifying the...

Thanks Mike

I guess the quantity should have been mentioned before. There are about 1600 tables to go though using that select command with an additional 700 views being skipped....

Here is the code that selects a list of tables to reindex then reindex. Hope I posted the code correctly.

declare @tabname varchar(255), @i int, @imax int

declare @tablst table (i...

Note to self - Must read replies more carefully and completely :blush:

Forgot to ask - Do I defrag with the SQL service running or stopped?

This article suggests you have to stop the service.

http://www.bradmcgehee.com/2011/06/do-you-ever-physically-defragment-your-sql-server-mdf-ldf-files/

but I imagine there are also articles...

I guessed the standard defrag tools would give a HDD fragmentation but was unsure if any way to tell about the actual SQL datafile fragmentaion. Sorry for not being...

This is what I like about forums. Different viewpoints so I can then look at what would suit our situation best. As with everything, there is no single...

@vineypugalia - Thank you for the comments. I shall leave the Master database alone then.

@Resender - There will be cases when something like this will be useful....

I am in a situation of being an accidental DBA to databases that are controlled by 3rd party. We are allowed to perform tasks on the engine but not...