Thanks Bill, you proved what I thought when I started the other thread.    Just out of curiosity, have you set any kind of...

There was a previous discussion on this topic here: http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=131125 that explains this to a point.  AFAIK you can't change the recovery mode on master in SQL Server 2000.  You can...

Sounds like a permissions issue.  What is the account that the SQL Server service is running under?  If it's the local system account, it won't be able to see the...

As Wes said, they're just files.  Find the backup file from the date and time that you want to copy.  It will have an extension of .bak with a DB...

Greg,

I said 'primarily' 9 to 5.  We do have apps and instances where users are in the office after hours or can dail in and perform updates, but I would...

Thanks for the replies.  To be safe, we've always been on site in the fall and just shut the agents down while the servers time synched, then brought them up...

Yes they are different.  The logs that your are viewing through Enterprise Manager are the activity logs for the SQL Server.  This includes startup messages, status of scheduled jobs completion,...

I stumbled across this web based product today while reading something else but haven't had a chance to try it out yet:

http://www.mylittletools.net/scripts/en/mla_sql/default.asp

Users need to be running IIS 5.0 or...

There's another discussion about this here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=131031.  That thread also contains a link to a Microsoft page with more detailed information about the build versions.  Long and short of...

Peter,

I can't navigate to the forum links you posted as I'm getting blocked by our internal web policies.  If you can elaborate on the issue some as to what specific...

The error states that a dll or one of it's references can't be found.  Have you used a dll explorer or dependancy checker to find out what else it's looking for? ...

Backup device data is stored in the sysdevices table of the master DB.  Querying this table will give you the location of the logical back up devices which are listed in...

Don't know if this helps, but we also saw this start showing up shortly after installing a service pack (SP 2 I think).  From what I could determine at the...

Native SQL encryption is not all that robust and there's a few tools around to do this although I've lost most my old links.  You can start here:  http://www.securiteam.com/tools/6J00S003GU.html

I can't speak...

I've had this happen sometimes as well with different network apps.  You can also use "right-click close" if you don't want to open Task Manager or if it isn't responding.  HTH.