if sql server is running under a network service you will need to assign permissions to the folder you are referencing in the code.

start here

http://technet.microsoft.com/en-us/library/bb839483.aspx

and keep reading 😉

if keeping log backups remember you also need the base backup(s) they are derived from

that is exactly what you do, specifying a new instance name each time

yes, run it as a VBS script. Check the property you have added, try running the script as i supplied. Can you post the script you ran

oops my bad, soory...

your welcome 😉

SQL ORACLE (7/29/2008)

---

So far only did SQLServerLifer give a right direction.

Device Manager does not provide the number of core processors.

System Information from System Tools does not provide this information either.

I...

a WMI query should produce this too

strComputer = "."

Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")

Set colItems = objWMIService.ExecQuery( _

"SELECT * FROM Win32_ComputerSystemProcessor",,48)

For...

you could ask your windows administrator or get the product type and tag and consult the server manufacturers website, if its Dell for example you could use the service tag...

so your backing up via a maintenance plan are you?

this is your windows OS build version, i am referring to SQL2005 SP2

the SQL product version being reported here

Microsoft SQL Server 2005...

just a thought, have you applied SQL2005 service pack 2 to the machine

eek now i'm getting worried 😀

how are you backing up the databases?

Via a maint plan or a custom job or maunal T-SQL script, etc?

GSquared (7/29/2008)

---

it's too high risk for us to run a script like that without knowing, from you, what's wrong with it. What if the problem you were running into...

the import wizard inside SSMS uses sql integration services so you have to have that installed.