Activity overview
Latest activity by PhilM
Hah! You made me look. I had thought there was only one, I only use one, but SQL Backup shows three (two named, one local). So I checked every way I know how:
Enterprise Manager: only one - (local)
SQL SERVICE Manager: only one (WEBSERVER = name of machine)
Task Manager: only one sqlserver.exe shows, uses NETWORK SERVICE acct
C:\Program Files\Microsoft SQL Server\.. shows three installs: MSSQL, and two that match the ones showing in SQLBackup
Finally SQLBackup shows the three (SBSMonitoring, (local), and Sharepoint)(in that order, which may be the whole point).
So the problem is partly a dumb install, but the main issue is that when following the wizard to create a backup job, it asks me to select an instance, I do, it even saves the selection (local) but when you come back to it to use the saved job next time, it DOES NOT select the instance you specified and says it cannot find your database (which of course is not in that instance).
Hope I have explained this ok... / comments
Hah! You made me look. I had thought there was only one, I only use one, but SQL Backup shows three (two named, one local). So I checked every way I know how:
Enterprise Manager: only one - (local)...
Backup Wizrad settings not saved multiple instances
On my new server, Windows 2003 SBS, set up by a contractor, there are multiple instances of SQL server 2000.
If I use Backup Wizard to create a backup, I can manually select the corrrect instance o...