thanks for all the good suggestions --

one thing i found out was that the trans logs were failing - couldnt figure out why --finally i remeber to check the backup...

thank you for the response.

the backup is going to the local c drive and the trans log is going to the local d drive - the server gets backedup...

no multiple instances.

about 8 months ago the sql and sql agent use to run under the local system account - it was changed to a domain account then -

i...

more info -

this is what i get when i run setspn -l

MSSQLSvc/servername.domain.com:2345

SMTPSVC/servername

SMTPSVC/servername.domain.com

host/servername

host/servername.domain.com

thank you - it was helpful -

yeah - studio doesnt show the agent part -

i checked the logs - i dont see anything related to this job when it fails (it is sql2000). i have studio express mgmt on a computer, i am able...

thanks - that worked -

how do i change the backup mode from simple to full for a specific database?

thanks --

i will get the info from the interface of the app - i think i can get the info i need this way -

thanks for all the suggestions

hi, i took a look at the tables - this database has 215 tables - each table has a unique id.

for example company id is co - user id is...

thanks for this info - very helpful indeed --

how could i write a query? for example - i need info from abc database and i need to exclude two parameters...

thanks for the response - i am new at managing sql and dont know how to do this --

like the querry or format or the method sql uses to pull...