June 18, 2009 at 6:56 am
i have an sql server 2005 express edition in my environment.since it is not having management studio,i am scheduling the backup for this server by remotely connecting this server from another server.but my backup job is getting failed throwing the eror backup path not foun.all the logins and all are correctly mapped...wat can be the solution
June 18, 2009 at 7:16 am
I think SQL agent is not inclued in Express Edition, so you cannot create maintenance plans and schedules.
you will have to use SQL Scripts to create backups and use windows schedular to schedule the backups.
Maninder
www.dbanation.com
June 18, 2009 at 7:34 am
The backup path u've specified should be present on the server (not on the client machine from where u're connecting)
You also might want to download express edition with advance services where u'll have SSMS.
June 18, 2009 at 8:01 am
how can we schedule this...how can we create the BAT file
June 18, 2009 at 8:09 am
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply