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

Activity overview

Latest activity by nagac

We can go with any one of these two methods. We are using SQLBackupC.exe as it is easy to use and we can directly execute it through cmd prompt. We have got temporary solution from Support for this solution but there is no solution for automation runas /netonly /user:domainuser cmd Backup works when I do this before I execute the actual Backup process. But this needs to be configured in system without using the above steps. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
We can go with any one of these two methods. We are using SQLBackupC.exe as it is easy to use and we can directly execute it through cmd prompt. We have got temporary solution from Support for this...
0 votes
But we are not supposed to execute the script as administrator in our organisation. As we have separate domain accounts which should be used to execute any batch processes or Agent jobs.which is why we are trying to solve this access related issues. thanks / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
But we are not supposed to execute the script as administrator in our organisation. As we have separate domain accounts which should be used to execute any batch processes or Agent jobs.which is wh...
0 votes
It will create database backup file without any exceptions. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
It will create database backup file without any exceptions.
0 votes
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
The User is under Administrators group, So it has rights on "Create Global Objects" / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Permissions Issue
The User is under Administrators group, So it has rights on "Create Global Objects"
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
Total activity
18
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2