thank you alen

ensure you upgrade to at least SP2 first though

no it wont work its looking for files older than 3 days. To delete files for a backup you just created change the day to minutes or seconds like so

set...

which mode are you trying to implement?

copy the file locally and restore from there!

if your issue is around sql server 2005 it would be best to post in the appropriate forum 😉

😉

is it a cd or dvd based image?

what version of sql server do you have installed and what version is the cd\dvd?

i'll check what i have on my server at the weekend and let you know back

it sounds like they may have been separated for adminstrative reasons. That's perfectly valid if that is what you want to do. As the server is licensed from the install...

Shabba (4/14/2010)

---

I quite like the term 'upgradation'... we all knew what the original op was trying to say!

A quick search within SSC will produce numerous topics on the subject of...

THE-FHA (4/14/2010)

---

And if the backup files that needs to be deleted are more than one and all of them are named using the instance_name and date, how will you go...

could you expand on this a little more please. What error do you get. Re running the installer will...

something along the lines of

declare @deldate datetime

set @deldate = cast(dateadd(day, -3 , getdate()) as nvarchar(20))

EXECUTE master.dbo.xp_delete_file 0,N'DRIVELEETER:\PATH',N'BAK',@DelDate, 1

should help

Hi

if you are currently using personal edition are you sure you need the massive leap to SQL Server 2005 Enterprise edition???

sivark1 (4/14/2010)

---

1)What r the best considerations to be taken...