|
|
Posted by Mark D Powell on 10/07/05 19:12
Recently I created a new db in production and restored it from test. I
have a nightly backup job that backs up all user databases. The backup
for this new db is failing.
The message in the error log is
2005-10-04 00:13:47.65 backup
BACKUP failed to complete the command BACKUP DATABASE [MTUDD_GEMINI
]
TO DISK = N'd:\sqldata\MSSQL\BACKUP\MTUDD_GEMINI \MTUDD_GEMINI
_db_200510040013.BAK'
WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
I notice that the file name seems to have a space in it between the
database name and the end of the backup _db and a space also appears at
the end of the directory name.
I can perform a backup successfully using the backup task under all
tasks under the database via Enterprise Manager.
Anyone seen this? Any suggestions other than backuping up the db
manually, dropping the database, recreating it, and restoring it from
the backup?
-- Mark D Powell --
Navigation:
[Reply to this message]
|