cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Can't backup SQL Express database

Jump to solution

I'm trying to backup an SQL database. When I'm going into database manager I'm able

to see the netperfmon database etc but when I try and backup it just say that the operation

failed. Has anyone else had this issue?

We are running NPM/NCM on XP and this could be the issue.

We are about to migrate to windows server and sql 2003 but it would be good to backup

first!

Thanks

Sam

Tags (2)
0 Kudos
1 Solution
Level 10

Hi There

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

-J

 

 

 

 

View solution in original post

0 Kudos
4 Replies
Level 18

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

0 Kudos
Level 10

Hi There

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

-J

 

 

 

 

View solution in original post

0 Kudos

Hi,

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?

0 Kudos

Yes this worked a treat. I just used it. Many Thanks

0 Kudos