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...

i have an SBS 2008 server which has the default sql server embedded instance installed for SBS monitoring. I also have extra instances installed for web databases. Have you tried...

This was enabled for SP3 CU4 on SQL Server 2005 Standard and SP1 CU2 for SQL Server 2008 Standard

do you mean recommendations from the tuning advisor?

was this some sort of joke then, maybe i am missing something vital, you always like...

hmm, yes i'm sure you do 😛