What is the filename extention of your backup files? Manitenance plan cleanup task deletes only .BAK/.TRN files.

Workaround is use FORFILES.EXE. Create a .BAT file and schedule it.

How do you backup without affecting the maintenance plan?

Schemabinding does not enhance UDF's performance.

It will make sure that the columns refered in the UDF/view are not dropped.

You can do this using Access.

Create ODBC linked table and queries.

TRUNCATE command

is the fastest way to delete ALL the rows from a TABLE, without filling up the transaction log.

1) Use DBCC CHECKTABLE to check the health of the table.

2) Use DBCC SHOWCONTIG to check the index fragmentation.

You can certainly write a scipt and schedule it.

MSDB database has details of all the backups done.

Check the following tables:

select * from msdb.dbo.backupfile

select * from msdb.dbo.backupset

select * from msdb.dbo.backupmediaset

select...

Also use

1) Query Execution Plan

2) SET STATISTICS IO/TIME ON/OFF

Right click on the publication you have created, select Properties, click Articles,

clear the check box "Show only selected objects in the list"

then select the table that you want to...

Use Notify Operator Task.

Did the Maintenace Plan run?

Check the history.

Have you mentioned the correct file path and extention.

Check how many days are there (default is weeks)

It should work.

It is very simple...

No. It doen't overwrite existing file as the new file names are different.

It deletes older BAK files. So free space will be created.

Are you backing up to same file?

Use Maintenance Cleanup Task to delete older BAK files.

127.0.0.1 is the reserved IP address of (localhost).

All servers have this.

No need to worry about this.

Hi Ahmed,

When a new database is created for the new client, this stored procedure can be altered.

As dynamic sql is not precomplied, I think conditional execution is faster.

However, I have...