Probably not your issue, but are the indexes across both databases identical. Is your query having to do table scans. Have you looked at the Query Governor. Also have you...

Hi, not sure if this is of much help however. I would be relunctant to automatically rollout SP's, hotfixes etc across servers. I appreciate you have over 400 boxes and...

Hi Steve, I never thought of BCP'ing out the data. But as you say if the data is that important, its worth a try. I reckon it will be hairy...

Hi again. Once the mdf is corrupt unless dbcc checkdb or dbcc cleantable can fix the coruption you will have to restore. And before so, rectify the hard disk issue....

Hi, Look up dbcc checkdb on books on line. I suggest dbcc checkdb(database, repair_rebuild) with ALL_ERRORMSGS. Also run a dbcc checktable ( tablename ). I know with Torn Page detected...

In order to reduce your LDF, you must back it up. Running checkpoint will write data from the ldf to disk. SQL Server itself issues checkpoints at predefined intervals. However to...

Hi, Just an FYI. I am experiencing the exact same problem in relation to looking at the properties of our production DB (which is on a clustered platform) from EM...

Dan, sorry didn't come across that issue before. But I will bear in mind for myself going forward. Anyway goes without saying don't forget, backup your system databases if you are...

Hi Dan, creating a step for each table would be a nightmare for you having so many. My idea behind sp_who2 (when you log on at time of freeze)...

Hi Dan, when you say Optimization freezes. Was there any blocking, ie run sp_who2. Also if your optimization is run from a wizard, perhaps you could create a separate...

Try http://www.red-gate.com/sql/sql_log_rescue.htm

I haven't tried it yet but their beta is free.

We use...

Thomas, when you say the Distribution job disappears, do you mean it disappears from the list of Distribution Agents under Replication Monitor or has the Distribution Agent Job in SQL Server...

Hi, hope I am not offending anyone by covering old ground. As previously mentioned, I looked at sp_spaceused and some other stored procedures and created my own. I intend now...

I'm new enough myself to SQL Server, however try... do a full backup of your database and move the .BAK file to the new server. Also script the Publication/Subscription and...

Hi There,

Fairly new to DBA aspects of sql server myself, however, we run a 24 by 7 operation. I take a full backup at night, every four hours differential and...