How do I edit a mssql backup script?

B

blazeking

Weaksauce
Joined
Nov 16, 2004
Messages
126
Ok when I'm not sure how to ask the question then I know I'm in trouble, but here's my question:

How do I view/edit a previously made backup script in MS SQL 2005? I'm new at this, and I created a backup, then "script action to job", but I wanted to edit the script after I made it. Where did it go? I checked scheduled tasks, and I have no idea where to look past that. Please help!
 
Are you doing all this in SQL Server Management Studio?
 
1) Connect to your server with object explorer
2) Expand the "SQL Server Agent" node
3) Expand the "Job" Node

you should find your backup job in there.
 
You must log in or register to reply here.
Back
Top