The reason you cannot do this is that Sql express Does not have the Sql agent By default as it is the free version. The database manager requires this agent to be running to allow you to backup databases in database manager. You would need to have the Full standard or enterprise edition of Sql to get this done.
One way you could do this if you want to do this on a scheduled basis is to script the action manually on Sql studio management express
1. Open this application
2. Right click on the Netperfmon database
3. Select tasks and backup
4. Add the destination for the backup
5. on the top right hand corner Select the script Button
6. This will generate a script For You
7. Save this Script and a.sql file
8. You can then run this as a scheduled task on your Windows machine.
The only other option would be to do this manually when you need to do a backup
Hope this Helps
Yes this worked a treat. I just used it. Many Thanks
What could be done when the database is runing on a remote SQL 2008 server machine? How can we make a scheduled backup on remote machine?
Since you're running NCM as well, you'll want to backup the ConfigMgmt database as well.
If SolarWinds DB manager isn't working, you might try downloading SQL Server Management Studio Express to see if that works any better: http://www.microsoft.com/downloadS/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en