Monday, March 19, 2012

Backup DATABASE is terminating

I continue to get the following error when creating SQL Backup from SQL
server to Backup server:
The file on device '\\SERSQL1V\SQLBACK\DATA\' is not a valid Microsoft Format
backup set. [SQLSTATE 42000] (Error 3242) BACKUP
DATABASE is terminating abnormally. [SQLSTATE 42000]
(Error 3013). The step failed.
SQLBACK is shared folder on the SERSQL1V and from another sql server2 i have
no problem to save backup file but from this new server i have this error
message and
Espen
Check tha tboth services (MSSQLSERVER and SQLSERVERAGENT) are using a domain
account with rights to write and read from / to the shared folder.
AMB
"Espen" wrote:

> I continue to get the following error when creating SQL Backup from SQL
> server to Backup server:
> The file on device '\\SERSQL1V\SQLBACK\DATA\' is not a valid Microsoft Format
> backup set. [SQLSTATE 42000] (Error 3242) BACKUP
> DATABASE is terminating abnormally. [SQLSTATE 42000]
> (Error 3013). The step failed.
> SQLBACK is shared folder on the SERSQL1V and from another sql server2 i have
> no problem to save backup file but from this new server i have this error
> message and
> --
> Espen
|||Now error message is
Cannot open backup device'\\SERSQL1V\SQLBACK\DATA\Trans'. Device error or
device off-line. Backup database is terminating abnormally.
Espen
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Check tha tboth services (MSSQLSERVER and SQLSERVERAGENT) are using a domain
> account with rights to write and read from / to the shared folder.
>
> AMB
> "Espen" wrote:
|||Are you doing a backup to a device or to a disk?
Can you post the statement used to do the backup?
AMB
"Espen" wrote:
[vbcol=seagreen]
> Now error message is
> Cannot open backup device'\\SERSQL1V\SQLBACK\DATA\Trans'. Device error or
> device off-line. Backup database is terminating abnormally.
> --
> Espen
>
> "Alejandro Mesa" wrote:
|||I am doing backup to a device. I am on the SERAX1V (This is SQL Server) and
making backup on the our Backup server name SQLSER1V (This is backup server).
I am using SQL Server Enterprise Manager for making backup.
Espen
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Are you doing a backup to a device or to a disk?
> Can you post the statement used to do the backup?
>
> AMB
> "Espen" wrote:
|||Can you view the contents of the device from EM?
AMB
"Espen" wrote:
[vbcol=seagreen]
> I am doing backup to a device. I am on the SERAX1V (This is SQL Server) and
> making backup on the our Backup server name SQLSER1V (This is backup server).
> I am using SQL Server Enterprise Manager for making backup.
> --
> Espen
>
> "Alejandro Mesa" wrote:
|||I can able to view the contents of the device (Server: SQLSER1V) from EM of
SERAX1V. I am just able to see the content of local server C, D and E.
Error log file shows
BACKUP failed to complete the command BACKUP DATABASE [ABFT] TO DISK =
N'\\SERSQL1V\SQLBACK\DATA\Trans' WITH NOINIT , NOUNLOAD , NAME = N'AxpMBF
backup', NOSKIP , STATS = 10, NOFORMAT
will i need to login with Domain and Local server Administrator? I am login
only with Local Server Administrator.
Espen
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Can you view the contents of the device from EM?
>
> AMB
> "Espen" wrote:
|||It is doing a backup to a file. From EM, right click over the server and
check what account is using the service in the security tab. Is it "system
account"?. The same if you right click over management - SQL Server Agent.
What account is being used under "service startup account", "system account"?
In both places, it should be a domain account, with enough rights to read
and write in the share folder.
See "Setting up Windows Services Accounts" in BOL for more info.
AMB
"Espen" wrote:
[vbcol=seagreen]
> I can able to view the contents of the device (Server: SQLSER1V) from EM of
> SERAX1V. I am just able to see the content of local server C, D and E.
> Error log file shows
> BACKUP failed to complete the command BACKUP DATABASE [ABFT] TO DISK =
> N'\\SERSQL1V\SQLBACK\DATA\Trans' WITH NOINIT , NOUNLOAD , NAME = N'AxpMBF
> backup', NOSKIP , STATS = 10, NOFORMAT
> will i need to login with Domain and Local server Administrator? I am login
> only with Local Server Administrator.
> --
> Espen
>
> "Alejandro Mesa" wrote:
|||Hei Alejandro
Thanks for your kind time it is going now very well!
Thanks a lot.
Espen
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> It is doing a backup to a file. From EM, right click over the server and
> check what account is using the service in the security tab. Is it "system
> account"?. The same if you right click over management - SQL Server Agent.
> What account is being used under "service startup account", "system account"?
> In both places, it should be a domain account, with enough rights to read
> and write in the share folder.
> See "Setting up Windows Services Accounts" in BOL for more info.
>
> AMB
> "Espen" wrote:

No comments:

Post a Comment