How can we help you today? How can we help you today?
nagac
Activity overview Badges (0) Posts (2) Comments (14)

Comments

Sort by recent activity
Hi Petey, You are absolutely right. Thanks Naga / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
Hi Petey, You are absolutely right. Thanks Naga
0 votes
Our Windows System Administrators has confirmed that the User id is having access. I just found something weird here, I had scheduled the script through windows task scheduler and it worked fine without any errors. however it doesn't work only when I run it manually. I used same user in both these cases. Thanks / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
Our Windows System Administrators has confirmed that the User id is having access. I just found something weird here, I had scheduled the script through windows task scheduler and it worked fine wi...
0 votes
I did it, and I could see the same userid which I used to run the commands. I googled the error and it says user id should have rights on Create Global Objects. Is that the one I need to look now? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
I did it, and I could see the same userid which I used to run the commands. I googled the error and it says user id should have rights on Create Global Objects. Is that the one I need to look now?
0 votes
osql -E -Q "SELECT IS_SRVROLEMEMBER('sysadmin')" 1 / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
osql -E -Q "SELECT IS_SRVROLEMEMBER('sysadmin')"1
0 votes
Hi Petey, Below are the outputs from the given commands osql -E -S .<your instance name> -Q "SELECT IS_SRVROLEMEMBER('sysadmin')" &#91;SQL Server Native Client 10.0&#93;SQL Server Network Interfaces: Error Locating Server/Instance Specified &#91;xFFFFFFFF&#93;. &#91;SQL Server Native Client 10.0&#93;Login timeout expired &#91;SQL Server Native Client 10.0&#93;A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. sqlbackupc -sql "BACKUP DATABASE model TO DISK = [<AUTO>]"' Backing up model (full database) to: C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBackupFULL_(local)_model_20150309_140200&#93;.sqb VDI error 1000: Access is denied. You may need to run SQL Backup using an account that has administrator rights on this machine. Memory profile Type Maximum Minimum Average Blk count Total ---------------- ----------- ----------- ----------- ----------- ----------- Commit 14293213184 4096 9847213 1506 14829903872 Reserve 51271106560 8192 301869827 170 51317870592 Free 8723836436480 4096 41970890299 208 8729945182208 Private 51271106560 4096 64652836 1021 66010546176 Mapped 4079616 4096 258808 70 18116608 Image 51929088 4096 203609 585 119111680 Warning 300: Backup failed. Retry attempt: 1 VDI error 1000: Access is denied. You may need to run SQL Backup using an account that has administrator rights on this machine. Memory profile Type Maximum Minimum Average Blk count Total ---------------- ----------- ----------- ----------- ----------- ----------- Commit 14293213184 4096 9847213 1506 14829903872 Reserve 51271106560 8192 301869827 170 51317870592 Free 8723836436480 4096 41970890299 208 8729945182208 Private 51271106560 4096 64652836 1021 66010546176 Mapped 4079616 4096 258808 70 18116608 Image 51929088 4096 203609 585 119111680 Warning 300: Backup failed. Retry attempt: 2 VDI error 1000: Access is denied. You may need to run SQL Backup using an account that has administrator rights on this machine. Memory profile Type Maximum Minimum Average Blk count Total ---------------- ----------- ----------- ----------- ----------- ----------- Commit 14293213184 4096 9866833 1503 14829850624 Reserve 51271106560 8192 303643896 169 51315818496 Free 8723836436480 4096 41970900420 208 8729947287552 Private 51271106560 4096 64905054 1017 66008440832 Mapped 4079616 4096 258808 70 18116608 Image 51929088 4096 203609 585 119111680 Warning 300: Backup failed. Retry attempt: 3 VDI error 1000: Access is denied. You may need to run SQL Backup using an account that has administrator rights on this machine. Memory profile Type Maximum Minimum Average Blk count Total ---------------- ----------- ----------- ----------- ----------- ----------- Commit 14293213184 4096 9847213 1506 14829903872 Reserve 51271106560 8192 301869827 170 51317870592 Free 8723836436480 4096 41970890299 208 8729945182208 Private 51271106560 4096 64652836 1021 66010546176 Mapped 4079616 4096 258808 70 18116608 Image 51929088 4096 203609 585 119111680 Warning 300: Backup failed. Retry attempt: 4 VDI error 1000: Access is denied. You may need to run SQL Backup using an account that has administrator rights on this machine. Memory profile Type Maximum Minimum Average Blk count Total ---------------- ----------- ----------- ----------- ----------- ----------- Commit 14293213184 4096 9847213 1506 14829903872 Reserve 51271106560 8192 301869827 170 51317870592 Free 8723836436480 4096 41970890299 208 8729945182208 Private 51271106560 4096 64652836 1021 66010546176 Mapped 4079616 4096 258808 70 18116608 Image 51929088 4096 203609 585 119111680 Warning 402: Failed to open local data store: Database already opened by a different user. &#91;Db name=C:ProgramDataRed GateSQL BackupData(local)data.sdf&#93; SQL Backup exit code: 1000 Warning 402: Failed to open local data store: Database already opened by a different user. &#91;Db name=C:ProgramDataRed GateSQL BackupData(local)data.sdf&#93; Thanks / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
Hi Petey, Below are the outputs from the given commands osql -E -S .<your instance name> -Q "SELECT IS_SRVROLEMEMBER('sysadmin')"&#91;SQL Server Native Client 10.0&#93;SQL Server Network Interfaces...
0 votes
Hi Petey, I have checked the roles the user id i am using while connecting to command prompt has sysadmin role. Sql backup Agent is running by using the same user. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
Hi Petey, I have checked the roles the user id i am using while connecting to command prompt has sysadmin role. Sql backup Agent is running by using the same user.
0 votes
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
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
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...
0 votes
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
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
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...
0 votes
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
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
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...
0 votes
Thanks eddi I thought it will be saved in physical locations. Anyways that makes sense Thanks / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Template default location
Thanks eddi I thought it will be saved in physical locations. Anyways that makes sense Thanks
0 votes
Total activity
18
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2