I do this to backup the database on our production server
BACKUP DATABASE [DP2] TO DISK = N'D:\mssql\data\MSSQL\BACKUP\DailyDbBack
up'
WITH INIT , NOUNLOAD , NAME = N'DP2 Backup Job', NOSKIP , STATS = 10,
NOFORMAT DECLARE @.i INT
select @.i = position from msdb..backupset where database_name='DP2'and
type!='F' and backup_set_id=(select max(backup_set_id) from msdb..backupset
where database_name='DP2')
RESTORE VERIFYONLY FROM DISK = N'D:\mssql\data\MSSQL\BACKUP\DailyDbBack
up'
WITH FILE = @.i
It works fine. However if I change to a mapped drive it gives me the
following error. I had agent running under the system account with failures
so thought I would change to my account, it also fails. I have full control
of that directory from this machine in windows. What gives?
Executed as user: DP2SQL02\jcantley. Cannot open backup device
'V:\DailyDbBackup'. Device error or device off-line. See the SQL Server
error log for more details. [SQLSTATE 42000] (Error 3201) BACKUP DATABASE
is terminating abnormally. [SQLSTATE 42000] (Error 3013) Associated
statement is not prepared [SQLSTATE HY007] (Error 0) Cannot open backup
device 'V:\DailyDbBackup'. Device error or device off-line. See the SQL
Server error log for more details. [SQLSTATE 42000] (Error 3201) VERIFY
DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step
failed.See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q17
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"JC" <striderguy56@.hotmail.com> wrote in message
news:OZ7MaIAIFHA.580@.TK2MSFTNGP15.phx.gbl...
I do this to backup the database on our production server
BACKUP DATABASE [DP2] TO DISK = N'D:\mssql\data\MSSQL\BACKUP\DailyDbBack
up'
WITH INIT , NOUNLOAD , NAME = N'DP2 Backup Job', NOSKIP , STATS = 10,
NOFORMAT DECLARE @.i INT
select @.i = position from msdb..backupset where database_name='DP2'and
type!='F' and backup_set_id=(select max(backup_set_id) from msdb..backupset
where database_name='DP2')
RESTORE VERIFYONLY FROM DISK = N'D:\mssql\data\MSSQL\BACKUP\DailyDbBack
up'
WITH FILE = @.i
It works fine. However if I change to a mapped drive it gives me the
following error. I had agent running under the system account with failures
so thought I would change to my account, it also fails. I have full control
of that directory from this machine in windows. What gives?
Executed as user: DP2SQL02\jcantley. Cannot open backup device
'V:\DailyDbBackup'. Device error or device off-line. See the SQL Server
error log for more details. [SQLSTATE 42000] (Error 3201) BACKUP DATABASE
is terminating abnormally. [SQLSTATE 42000] (Error 3013) Associated
statement is not prepared [SQLSTATE HY007] (Error 0) Cannot open backup
device 'V:\DailyDbBackup'. Device error or device off-line. See the SQL
Server error log for more details. [SQLSTATE 42000] (Error 3201) VERIFY
DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step
failed.
Sunday, February 19, 2012
Backup ?
Labels:
backup,
dailydbbackup,
database,
disk,
dp2,
microsoft,
mssql,
mysql,
oracle,
production,
server,
serverbackup,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment