I have two issues I am trying to address, one of which I have a messy work around for once I have resolved the other!
1. Is it possible to schedule an SQL Server Express server to run a backup out of hours ie no users using the database.
2. I notice that when manually running a backup the backup device is restricted to tape or the C: drive, due to the SQL account not having network access.
So my work around is to have a batch program kick off after I know the backup has completed and copy the backup file to a file server.
Any tips or comments?
Thanks
1. Is it possible to schedule an SQL Server Express server to run a backup out of hours ie no users using the database.
2. I notice that when manually running a backup the backup device is restricted to tape or the C: drive, due to the SQL account not having network access.
So my work around is to have a batch program kick off after I know the backup has completed and copy the backup file to a file server.
Any tips or comments?
Thanks