May 16, 2009 at 7:58 PM


I installed sqlexpress2008 on xp home and then run an expressmaint backupscript on it and it works fine.

I then installed sqlexpress on another pc (xp pro) and the same backup script does not work when run on that pc. I am under the impression they are setup the same. It does not create any erros but does not see any of the databases. If I specify the db name to backup, then it creates an error saying it can't find the db.

I presume this is a setting in sqlexpress, can you help?



May 16, 2009 at 11:15 PM

Does the following query return any results when run against the instance that is not being backed up?

select distinct d.name,case when d.database_id < 5 then 1 else 0 end as IsSystem,d.recovery_model
from sys.databases as d
join sys.master_files as f on d.database_id = f.database_id
where d.state_desc = N'ONLINE'
and d.source_database_id is null
and d.name not like f.physical_name

May 18, 2009 at 7:54 AM

Hi Jasper,

 Thanks for the quick reply.


Unfortunately I don’t have access to the installation. I’ll have to try to reproduce the issue on another PC to see what the below produces.


Is there anything else I could check other than the below? Do you think I am right in saying it is something to do with the DB installation?


By the way, thanks for making this program. It has made my life easier!






May 18, 2009 at 4:11 PM

That's the query used to enumerate the databases. If it doesn't return any databases (and it should always return at least 4 for the system databases) then that would explain why the tool is not backing anything up :-) The account you run the tool under must have sysadmin rights to the instance.

May 20, 2009 at 8:08 PM

Hi Jasper,


Yes you were correct. The account did not have sysadmin ticked. Thank you for your help.


Kind regards