Anamika (10/15/2010)

---

Hi all,

Before going for a live data base what are the things we need to consider and steps should be taken as a vibrant intuitive DBA?

On memory utilization, space,...

GilaMonster (10/14/2010)

---

Yup.

Currently watching them test to see if a cup of soda can kill you through a windscreen if thrown while cars travelling at highway speed. Actually...

there is no native SQL facility to do this without a backup. Investigate third party tools that may be able to extract data out of logs. Although as the command...

sounds like someone truncated your database log. Take another full backup and restart logshipping from the next log after that full backup.

master cannot be taken out of simple recovery mode so cannot do log backups. How often you back it up depends on how much it changes in your environment. If...

Gianluca, looks like you have it covered. You may need to experiment to get the best fill factor for your busy tables.

Ninja, perhaps I should have come up with a...

Just in case you did not realise Gianluca this step may be superfluous. If your index rebuild is the default maintenance...

its naughty because it is arbitrarily setting all fillfactors for all indexes to 90%. The index may not have been originally created with that fillfactor and there may have been...

thanks for replying guys and as your reward you get to see some info that might help you one day.......

Reran optimisations in various ways on the 'fixed' database with the...

I think Chris means with the use of AWE SQL2000 enterprise can use above the 4Gb line. With that set up I would allocate up to 10GB to SQL (leave...

Are you sure the data repositories are being backed up? if they are in a state to receive log backups it will not be possible to back them up.

there is...

and SP2 is out so perhaps you should slipstraem that.

good point Gianluca.

Its not parallelism in our case, Query runs serial.

I forgot to mention Index was rebuilt with 100% fillfactor when it was 90% before (accidentally :-), but if its...

download a free tool call SQLIO and test. This tool will measure your maximum throughput

thanks for the reply craig.

couple of things have been found, restored a different backup, ran a dbreindex script (not a maint plan one) and query was not affected, ran in...