Easy way to Delete Old backup files !!!

Use the Forfiles utility to delete old database backup files.

The Forfiles utility (forfiles.exe) comes installed with Windows Server 2003 and later. Forfiles enables batch processing of files. In conjunction with a SQL Server Agent job, you can use this utility to delete old database backup files to remove dependencies on items such as SQL Server maintenance plans, the xp_cmdshell extended stored procedure, or VBScript objects. For example, the following command uses Forfiles to delete all .bak files that are two days old or older in the E:\sqlbackup folder:

forfiles /p "e:\sqlbackup" /m "*.bak"

/c "cmd /c del /Q @path" /d -2

How to view all sql server instances from the network

Call Start->Run type cmd and click enter (start command line prompt). Now depending on version of installed sql server client tools run either from the following commands

--> sqlcmd -L

--> osql -L

--> isql -L


Try them in the given order. sqlcmd is the latest version of command line sql server utility. All of this utilities support -L param which lists all sql server instances from the network. However, isql shows only sql servers of 7.0 version and below, osql - only sql server 2000 and below and sqlcmd shows all sql server instances from the network. So to view all sql server in the network you better use sqlcmd -L command.

Step by Step build RAC : Part 1 : Install VMWare and Linux

Post: 1

Installing Oracle RAC in your Home on a single Machine using Vmware.

Please download the document from the link provided below and enjoy with RAC

http://rapidshare.com/files/309045213/Step_by_step_Installation_of_Oracle_RAC_Database_on_single_machine_using_VMWare_Server.pdf