|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: Tuesday, February 23, 2010 8:51 AM
Points: 171,
Visits: 458
|
|
Hi all,
I amnew to this env. How can i backup SQL Express 2005 database. I tried installing SSMS but it did not let me. How can i do backup from command level?
Thanks
|
|
|
|
|
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 2:45 PM
Points: 8,681,
Visits: 4,953
|
|
It won't let you install SSMS? That seems strange. Did it give you an error message on that?
- GSquared
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Thursday, March 04, 2010 11:58 AM
Points: 10,
Visits: 98
|
|
Just so you know, SSMS Express (if that is what you are trying to install) doesn't support scheduled backups. If your app that is using the SQL Express database doesn't support scheduled backups you'll have to rely on a third party backup product or write a stored procedure, call it from a sql script that you execute with SQLCMD from the Windows Schedule Tasks.
Steve
Senior DBA
SQL Managed
www.sqlmanaged.com
|
|
|
|
