Comments
Sort by recent activity
Hi Petey,
Sorry for the delayed response this is due to the licensing issue with the product.
I have got the below output:
Backing up model (full database) to:
C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBackupFULL_(local)_model_20150306_101021.sqb
Database size : 2.750 MB
Compressed data size: 198.000 KB
Compression rate : 92.97%
Processed 168 pages for database 'model', file 'modeldev' on file 1.
Processed 1 pages for database 'model', file 'modellog' on file 1.
BACKUP DATABASE successfully processed 169 pages in 0.052 seconds (25.390 MB/sec).
SQL Backup process ended.
exitcode 0
sqlerrorcode 0
filename001 C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBackupFULL_(local)_model_20150306_101021.sqb
Thanks / comments
Hi Petey,
Sorry for the delayed response this is due to the licensing issue with the product.
I have got the below output:
Backing up model (full database) to:
C:Program FilesMicrosoft SQL ServerMS...
I tried as you said, and the Backup is successful Petey, However the backup is failed when I tried using my script command.
SQLBackupC.exe -E -SQL "BACKUP DATABASE [%%I] TO DISK='%DBBACKUP_PATH%!DBBACKUPFILENAME!' WITH PASSWORD = '<ENCRYPTEDPASSWORD>IxY6YeZHYWfKje1nc/a5Y97mc3XalU5piw==</ENCRYPTEDPASSWORD>', COMPRESSION = 4 / comments
I tried as you said, and the Backup is successful Petey, However the backup is failed when I tried using my script command.
SQLBackupC.exe -E -SQL "BACKUP DATABASE [%%I] TO DISK='%DBBACKUP_PATH%!D...
Thanks for the response petey,
Yes, it has sysadmin role. Backup work's well when I manually do it through GUI. But only the issue with Script.
I found an error in Application Event Log as below that might give you some more info to narrow the error.
SQLVDI: Loc=CVDS::CreateEx. Desc=Create Memory. ErrorCode=(5)Access is denied.
. Process=5356. Thread=1612. Client. Instance=. VD=GlobalSQLBACKUP_156C4973-E676-4BE9-B29A-66C355EA5276_SQLVDIMemoryName_0.
Thanks / comments
Thanks for the response petey,
Yes, it has sysadmin role. Backup work's well when I manually do it through GUI. But only the issue with Script.
I found an error in Application Event Log as below th...
Thanks eddi
I thought it will be saved in physical locations. Anyways that makes sense
Thanks / comments
Thanks eddi
I thought it will be saved in physical locations. Anyways that makes sense
Thanks