June 21, 2006 at 1:27 pm
i back up my data base every night to lto3 tape with arcserve
ver 11.5 when i try to restore from tape i get this error:
W3402 06/15/2006 12:33:27 PM 876 1 Unable to create file. (FILE=F:\test\:pRIMARY:LAN_Data>62490944 D?K:\MSSQL$SQL_WEB\Data\LAN.ldf, EC=INVALID NAME)
W3402 06/15/2006 12:33:27 PM 876 1 Unable to create file. (FILE=F:\test\:pRIMARY:LAN_Data>62490944 D?K:\MSSQL$SQL_WEB\Data\LAN.mdf, EC=INVALID NAME)
any idea ?
June 26, 2006 at 8:00 am
This was removed by the editor as SPAM
June 27, 2006 at 2:34 am
dear ,
use the restore methord with move option.
For more information see BOL for move option.
from
Killer
June 27, 2006 at 7:17 am
How do you backup the databases? You CANNOT just 'copy' the .mdf and .ldf files to tape. It won't work...well, you can copy them, but they are unusable.
There are two main ways to do backups.
1. Use the SQL Server backup commands (some third-party backup software use these commands, but they require 'agents' - such as Veritas' Backup Exec Agent for SQL Server).
2. Take the database offline (stop the SQL Server services or detach the db) and then backup the .mdf and .ldf files.
-SQLBill
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply