i just tryed it when try to restore sql generate an error msg, and u cant restore untill drop the snapshot first

try this link

http://www.sqlservercentral.com/Forums/Topic489736-357-1.aspx?Update=1

and this is the job script:

USE [msdb]

GO

/****** Object: Job [delete old backup file] Script Date: 04/24/2008 13:19:39 ******/

BEGIN TRANSACTION

DECLARE @ReturnCode INT

SELECT @ReturnCode = 0

/****** Object: ...

1- create a batch file to delete files older than like 7 days.

2- create a job to run this batch.

try to use this one to delete files(copy the code and...

i did tried so but no it didnt worked.

am thinking off creating a snapshot for the database, this should do the job right?

there is some thing called DDL triggers but i couldnt find some thing related to restore or backup.

if u cant write the script then use the GUI..

there every thing is clear

i was wondering if i could create like a trigger to prevent a restore over the database.

its easy to say this.

but any way u r right there is no way, but i was looking for a hope.

any way thanks alot

thanks for this am haviong the same problem and i did just what uve said, and its working fine.

how did u came with this??

thanks all.

ur solution were v.smart.

thanks a lot for the help.

thanks.

do any one have a solution if i need to run this select every 2 seconds?

i have been trying but am stuck in a dead end.

do u mean that there is no buplic on 2005??

there should be one on every database.

u can consider creating a second log file.

in ur case the first condition is always true.

cos u r comparing A with ALL