Thanks Osama,

Now evrything is fine. But Iam confused in scheduling the jobs for deleting .bak files and .trn files using this VBSCRIPT. Here is the scenario:

Hi,

We have scheduled...

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 question...

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 as...

Could give me some more information and guidelines about the following

we have sql server 2005 EE x64 on windows 2003 R2 EE. We have 16GB RAM and I set Max...

Iam able to see the report in the actual report server. But Iam getting this error when tried see the report from other machines in the same domain.

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. I...

page file size is default value 2046MB

we have sql server 2005 EE x64 on windows 2003 R2 EE. We have 16GB RAM and I set Max memory 12GB and the sql server is taking whole 12GB.We...

If we add new secondary datafile to existing production database, how the data will be shared between mdf and newly created ndf file? do we need to move data from...

Could please tell me how to give the access to a newly created folder

Here is the link

http://technet.microsoft.com/en-us/library/ms156016(SQL.90).aspx

Thank You

Where exactly I can insert this script in the original script I posted?

Check the following information before you install SP3 on a failover cluster instance:

?Do not stop the cluster service before you run the SP3 Setup program, or while the installation program...

could you please provide me some kind of script which deletes old backup files. Currently Iam using xp_cmdshell, which is not recommanded as I read many times in this forum.So...

Hi Peddie,

Using the deploy option in visual studio or BIDS allows the developer to deploy rdl files to SSRS(ServerA).I went through the system level and item level roles in Report...