Hi David

just to add something to what grant has said so far.

You can also have a look at third party management tools which provide you with inbuilt version control...

Also, there are third party tools available. some of the good ones are listed below;

1. Red Gate SQL Backup

2. Idera Sql Safe Backup

Vivek

is your backup generated in the setup network folder? Did you give sufficient rights on that directory?

GilaMonster (8/11/2009)

---

Index 255 is the table's LOB data (text, ntext, image, varchar(max), nvarchar(max), varbinary(max)). It's not a real index.

p.s. since you're on 2005, perhaps start using sys.dm_db_index_physical_stats, ALTER INDEX ......

Further investigation:

I have checked sysindexes table and this index exists and been used 113 tiems.

Also, I have found couple of indexes like this and they all have one thing...

No worries!

Happy to be of help.

Vivek

I can think of couple of solutions. Please see below.

1. you can write a batch file.

2. you can write and build a simple vb app or c# app then...

San (8/7/2009)

---

Dear All,

I want to delete only PDF files, which are older than 3 days from a particular folder.

Is it possible to do it using SQL jobs.?. I tried with...

John Bates (8/4/2009)

---

Hi,

This is SQL Server 2005 SP2

I installed Reporting Services but had some difficulties when I went thru the Configuration steps. It was having authentication permission - maybe because...

You are most welcome.

Also, I have attached some articles on Index Tuning which i though might be useful.

Query execution plan analysis

http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx

finding the cause of poor performance

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/...

Hi Maxer

Did you give idera's SQL diagnostic manager?

I'd say it will give you a good start while you may explore other options towards resolving your problems. It is a...

also if you wanted to export generated maintenance plan to file system you could do that.

Sorry Jim, i should have been bit more clearer there. What i wanted to say was create jobs in terms of scripts. you can...

also, you can script them and source control them.

please make sure you are connected to server. sql server generates this message when connection to server is lost.