Gift Peddie (7/24/2009)

---

dont think I quite understand, Code is simply data if you could recover all your data then why are you not able to recover all your code?...

I dont think you can blame Toshiba for a lack of source control, as there a plenty of source control solutions that will happily run from a low-grade server

Gift Peddie (7/24/2009)

---

Ok I am assuming there is a comprehension problem here data is just part of what is lost recovery from data pedestrian. While code is not so...

The code that is recommended for SQL 2005 can be found in books on line under 'sys.dm_db_index_physical_stats' .

It is very similar to the code in "DBCC SHOWCONTIG" page

try this script out;

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31929/

All the sample data bases including AdventureWorks are available on CodePlex

http://msftdbprodsamples.codeplex.com/

http://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=MSFTDBProdSamples&ReleaseId=4004

middletree (7/22/2009)

---

steveb (7/22/2009)

---

middletree (7/22/2009)

---

When I posted the message, it included the bad stuff. But this forum stripped it out, which is understandable. It was an HTML script tag, followed by...

middletree (7/22/2009)

---

When I posted the message, it included the bad stuff. But this forum stripped it out, which is understandable. It was an HTML script tag, followed by a link...

If you are buying Licenses you may want to look at 2008...

You wont...

try this one out ..

http://www.sqlservercentral.com/scripts/31857/

What are the Autogrowth settings for your database?

Have a look at the SQL agent error log, this will give a better description of why the plan failed..

Are there any other errors prior to this one in the error log?

There is a view that you can query

select * from sys.database_mirroring

you can read more about the mirroring catalog views on

http://msdn.microsoft.com/en-us/library/ms178655(SQL.90).aspx