May 20, 2008 at 1:52 pm
Hi,
does any body know how to automatically backup all the databases on sql server express 2005.
kindly recommend.
May 20, 2008 at 4:44 pm
I have a solution for this that you are welcome to use.
http://ola.hallengren.com/sql-server-backup.html
sqlcmd -E -S .\SQLEXPRESS -d master -Q "EXECUTE [dbo].[DatabaseBackup] @databases = 'SYSTEM_DATABASES,USER_DATABASES', @Directory = 'C:\Backup', @BackupType = 'FULL', @verify = 'Y', @CleanupTime = 24" -b
Ola Hallengren
May 21, 2008 at 10:41 am
hi,
thanx for the solution, can you suggest
if i backup the directory of the ms sql server express,
if there is data corruption in ms sql express will it be possible to restore the database using the files that we backed up by copying the directory of ms sql express.
what do you suggest.
May 21, 2008 at 10:53 am
I think that you should do full backups of all user and system databases to .bak files (using my or some others script). You should also have something that copies these .bak - files outside of the server.
If a database would get corrupted or a server would crash, you could restore the .bak files to get the databases back online.
Ola Hallengren
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply