SQL Express backup 2

[pinkpanther56]

Hi all

I've downloaded the SQL Server management studio and used it to backup my SQL Db, is there a way to schedule this feature to backup the Db before our tape backup runs?

Thanks.

 

[ptheriault]

SQL Server express doesn't support SQL Server agent job scheduling. You could put the backup command in a file and use sqlcmd and windows schedular to execute it.

- Paul
- Database performance looks fine, it must be the Network!

 

[pinkpanther56]

So it's not even possible with the management studio?

How do i use sqlcmd to perform a backup can you provide a link to some information?

Thanks.

 

[ptheriault]

you can manually run the command but you can't schedule the job. Use windows task schedular to execute a bat file that will backup you database.

- Paul
- Database performance looks fine, it must be the Network!

 

[ptheriault]

from a cmd prompt type this.

sqlcmd
<enter>
backup database master to disk = 'c:\program files\backup\master.bak'

You can create a bat file from this code that you can execute using windows task schedular.

- Paul
- Database performance looks fine, it must be the Network!

 

[pinkpanther56]

Excellent i'll give that a try thanks.