Now, Using this VBSCRIPT, Do I need to create 3 jobs each for one backup folder to delete files in them or Can I create 1 job and add ...

change the owner as said before....

try login with windows credential

Nisha (2/12/2009)

---

When I right click a database (MyOldDatabase) in SQL Server 2005 Management Studio, I get the following message:

Property Owner is not available for Database '[MyOldDatabase]'.

This property may...

kotlas7 (2/12/2009)

---

Thanks Osama,

Its working after changing set oFolder = oFSO.GetFolder("C:\reports\") to set oFolder = oFSO.GetFolder(sDirectoryPath).Now able to delete the backupfile and also its logging what files it is deleting.

One more...

kotlas7 (2/12/2009)

---

Hi Osama,

The 2nd script is NOT deleting the Backup files But it is creating an empty log.txt file in C:\log.txt.

Could you please make it work to delete backup files...

kotlas7 (2/12/2009)

---

Thanks Osama,

With this Script Iam able to delete backup file 'n' days older But its not logging what it is deleting in C:\log.txt as you mentioned in the script....

shri_sastry (2/10/2009)

---

I tried to build a maintenance plan, but I am getting the following error when I do it. I using the maintenance plan wizard in SQL 2005. If anyone...

Here is da complete script...

Option Explicit

on error resume next

...

shri_sastry (2/9/2009)

---

Thanks

I think we will change the reindexing to once a week instead of once a day. This was on the test server where the transaction...

u can use this function as

LogMessageToFile(Filename)

Public Sub LogMessageToFile(ByVal Message As String)

Dim LogFileName As String = "C:\LogDeletedFile.txt"

...

kotlas7 (2/8/2009)

---

Hi Osama,

From BOL..

The databases can run on a local or remote SQL Server instance. Choosing a local instance is useful if you have sufficient system resources or want to...

ALZDBA (2/8/2009)

---

Indeed,Ahmad Osama, that is the best way (especially because downtime is not an issue) !

(I was just reflecting on that this morning, you know how that goes 😉 )

Or...

do u mind telling us that how this will better the performance.

dbv147 (2/6/2009)

---

Hello,

I need to move an index file to another drive and thought I'd get some advice on the best way to do this. The index is on an archive...