I need an automated backup for SQL 2005 Express.
I used studio manager to create the backup script.
I am currently using task manager to run the script.
How can I run it without showing the username and password?
Here is what I know:
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCM
D.EXE -S [SERVER] -U bakupadmin -P [PASSWORD] -i D:\backup\sql\SQLExpressBa
ckups.sql
Is there a better way?
Start Free Trial