Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
charlemagne
Starting Member
3 Posts |
 Posted - 2010-03-30 : 22:44:50
|
| I get this message when BackupExec tries to backup the SQL database:Backup- D: SpareUnable to open the item D:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\BackupTest.mdf - skipped.Unable to open the item D:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\BackupTest_log.ldf - skipped.Is there any way to have SQL Server either close the database at night and reopen it in the morning, or at least output a backup-able snapshot on a daily basis?TIA. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
charlemagne
Starting Member
3 Posts |
Posted - 2010-03-30 : 23:00:11
|
| [quote]Originally posted by tkizerBut really don't bother with that as you should be taking backups from SQL Server and then just sweep those files to tape.Can you clarify please? Do you mean use SQL Management to take a backup from SQL server, deposit the backup file somewhere where BackupExec will see it and then let BackupExec copy to tape? [Is there any way to automate that to run daily?] |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Backing up SQL Server Express db with BackupExec