-
Issues using xp_delete_file
When I run the script bellow on my local sql server instance it works just fine. I can backup master then It will delete without any issues.
But... When I go to run this on my production server the backup is created but not deleted. I'm not seeing any errors. The SQL versions are the same SQL 2008 sp1.
Any ideas?
Thanks.
BACKUP DATABASE model TO DISK = 'C:\model.bak'
WAITFOR DELAY '00:00:10'
EXECUTE master.dbo.xp_delete_file 0,
N'C:\',
'bak',
'2010-01-01T00:00:00'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|