Sunday, March 11, 2012

backup database (sql server backup) and files (nt backup)

Hi!
pls. advise, I need to backup some files on hard drive
using NT backup utility and SQL Server database (using sql
server db backups) to one tape. If I backup first some
folders and files with nt backup utility and then sql
server database, the sql server database cannot be
restored ("not a valid sql server backup"). In the other
case (first backed up sql server db then files using nt
backup) I am getting message "inconsistent media, do not
append to this tape"
How can I solve this?You must use the SQL Server BACKUP command to create a backup file on disk
(or directly to tape) first. Then you can copy this file to tape. You can
not backup the sql files directly with a native NT backup.
Andrew J. Kelly SQL MVP
"Gabriel" <anonymous@.discussions.microsoft.com> wrote in message
news:12d3001c418b3$612a9610$a001280a@.phx
.gbl...
> Hi!
> pls. advise, I need to backup some files on hard drive
> using NT backup utility and SQL Server database (using sql
> server db backups) to one tape. If I backup first some
> folders and files with nt backup utility and then sql
> server database, the sql server database cannot be
> restored ("not a valid sql server backup"). In the other
> case (first backed up sql server db then files using nt
> backup) I am getting message "inconsistent media, do not
> append to this tape"
> How can I solve this?

No comments:

Post a Comment