How can we help you today? How can we help you today?
stan
Activity overview Badges (0) Posts (3) Comments (11)

Comments

Sort by recent activity
Hi Ben, i tried using SQL Compare and it shows me the same error "Unable to cast object of type 'System.DBNull' to type 'System.String'. Tanya, i checked and the dbo user is mapped with my user 'dba' which is sysadmin and still it doesn't works, also databases as you said were not taken offline. I forgot to tell the title from the error message, it says "SQL Prompt could not retrieve the database schema", the other text i posted was the error details. Thanks for the help in advance. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Object cache lecture fails
Hi Ben, i tried using SQL Compare and it shows me the same error "Unable to cast object of type 'System.DBNull' to type 'System.String'. Tanya, i checked and the dbo user is mapped with my user 'db...
0 votes
Hi Petey I was running the testing backup rights script and found something that happens with the databases I can't backup, while running the query from the Management Studio connected to another database (other than the one I can't backup) the script won't finish running (I left the script running more than 30 minutes and nothing) and I noticed that in the middle of the script (inside the first 'IF' statement where it verifies if the user is sysadmin) it has the following statement: USE [MonitorMedios] where 'MonitorMedios' is the database I can't backup, but when I remove the use statement the query doesn't delay even 1 second, it runs fast, also if I previously use the Use statement to connect to the database MonitorMedio it runs in 0 seconds. I don't even know why does this affects the script because it should never get inside the IF becuase my user is a sysadmin, maybe is something with the compiler. Thanks / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Database Permission Denied
Hi Petey I was running the testing backup rights script and found something that happens with the databases I can't backup, while running the query from the Management Studio connected to another d...
0 votes
Dear Petey Sorry, have you found any solution for my problem? Thanks. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Database Permission Denied
Dear Petey Sorry, have you found any solution for my problem? Thanks.
0 votes
Yes, I don't why this happens, here is the code I am trying: -- Testing for BACKUP rights. -- Work from server role to database role, to BACKUP DATABASE execution and restriction rights. -- # Aliases are not supported. DECLARE @hasrights INTEGER SELECT @hasrights = IS_SRVROLEMEMBER('sysadmin', 'dba') IF ( @hasrights = 0 ) OR ( @hasrights IS NULL ) BEGIN SETUSER 'dba' -- As long as the user has sysadmin server role, he can backup the database. SELECT @hasrights = IS_SRVROLEMEMBER('sysadmin') IF ( @hasrights = 0 ) OR ( @hasrights IS NULL ) BEGIN -- This has to be done because IS_SRVROLEMEMBER does not check recursively if a login name is provided. USE [MonitorMedios] DECLARE @login_type INTEGER DECLARE @login_name SYSNAME -- No sysadmin rights. Check for database db_owner role. SELECT @hasrights = IS_MEMBER('db_owner') -- Check for database db_backupoperator role. IF ( @hasrights <> 1 ) BEGIN SELECT @hasrights = IS_MEMBER('db_backupoperator') END -- No db_backupoperator role. Check BACKUP DATABASE execute rights. -- Quick check for explicit rights. IF ( @hasrights = 0 ) OR ( @hasrights IS NULL ) BEGIN SELECT @hasrights = 1 WHERE EXISTS ( SELECT 1 FROM sysprotects a INNER JOIN sysusers b ON a.uid = b.uid AND b.name = 'dba' WHERE a.action = 228 AND a.protecttype IN ( 204, 205 ) ) IF ( @hasrights = 0 ) OR ( @hasrights IS NULL ) BEGIN -- No direct rights. Now need to iterate and check all Windows groups and SQL Server roles. DECLARE cur_rights CURSOR FOR SELECT ( CASE WHEN b.isntgroup = 1 THEN 1 ELSE CASE WHEN b.issqlrole = 1 THEN 2 ELSE 0 END END ) type, b.name FROM sysprotects a INNER JOIN sysusers b ON a.uid = b.uid WHERE a.action = 228 AND a.protecttype IN ( 204, 205 ) AND ( b.isntgroup = 1 OR b.issqlrole = 1 ) OPEN cur_rights FETCH NEXT FROM cur_rights INTO @login_type, @login_name @FETCH_STATUS = 0 BEGIN SELECT @hasrights = IS_MEMBER(@login_name) IF @hasrights = 1 BEGIN BREAK END FETCH NEXT FROM cur_rights INTO @login_type, @login_name END CLOSE cur_rights DEALLOCATE cur_rights END END -- for database level rights, need to check if DENY restriction exists IF @hasrights = 1 BEGIN SELECT @hasrights = 0 WHERE EXISTS ( SELECT 1 FROM sysprotects a INNER JOIN sysusers b ON a.uid = b.uid AND b.name = 'dba' WHERE a.action = 228 AND a.protecttype IN ( 206 ) ) IF @hasrights = 1 BEGIN -- No explicit DENY restrictions. Check via group / role membership. DECLARE cur_rights CURSOR FOR SELECT ( CASE WHEN b.isntgroup = 1 THEN 1 ELSE CASE WHEN b.issqlrole = 1 THEN 2 ELSE 0 END END ) type, b.name FROM sysprotects a INNER JOIN sysusers b ON a.uid = b.uid WHERE a.action = 228 AND a.protecttype = 206 AND ( b.isntgroup = 1 OR b.issqlrole = 1 ) OPEN cur_rights FETCH NEXT FROM cur_rights INTO @login_type, @login_name @FETCH_STATUS = 0 BEGIN SELECT @hasrights = IS_MEMBER(@login_name) IF @hasrights = 1 BEGIN SET @hasrights = 0 BREAK END FETCH NEXT FROM cur_rights INTO @login_type, @login_name END CLOSE cur_rights DEALLOCATE cur_rights END END END SETUSER END DECLARE @dbname SYSNAME SELECT @dbname = name FROM master..sysdatabases WHERE name = N'MonitorMedios' IF @hasrights = 1 SELECT CAST(1 AS INT) AS hasrights, @dbname AS name ELSE SELECT CAST(0 AS INT) AS hasrights, @dbname AS NAME / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Database Permission Denied
Yes, I don't why this happens, here is the code I am trying: -- Testing for BACKUP rights. -- Work from server role to database role, to BACKUP DATABASE execution and restriction rights. -- # Al...
0 votes
Hi petey, thanks for the info, I finally got the testing rights script, but when I try to run it everything seems fine, in the following validation: DECLARE @hasrights INTEGER SELECT @hasrights = IS_SRVROLEMEMBER('sysadmin', 'dba') IF ( @hasrights = 0 ) Which is the very first 'IF' from the script @hasrights value is 1 and finally the script shows me the @hasrights column with 1 and the database name that i can't make backup from. dba is the user i have configured for SQL Backup and it has sysadmin rights. Thanks. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Database Permission Denied
Hi petey, thanks for the info, I finally got the testing rights script, but when I try to run it everything seems fine, in the following validation: DECLARE @hasrights INTEGER SELECT @hasrights = ...
0 votes
No, there's not a CommandTiemout setting in the registry folder, should I create one? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Database Permission Denied
No, there's not a CommandTiemout setting in the registry folder, should I create one?
0 votes
Hi petey I tried to run the profiler while sql backup was running, also while it was doing a database backup and the only data text profiler shows me from SQL Backup that says something like test is the following: -- sp_verify_job_identifiers IF (@sqlagent_starting_test = 'TEST') or -- sp_help_jobschedule EXECUTE @retval = sp_verify_job_identifiers '@job_name', '@job_id', @job_name OUTPUT, @job_id OUTPUT, 'NO_TEST' Otherwise i can't see in the profiler the -- Testing for BACKUP rights. I am looking all the TSQL events in profiler. Thanks. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Database Permission Denied
Hi petey I tried to run the profiler while sql backup was running, also while it was doing a database backup and the only data text profiler shows me from SQL Backup that says something like test i...
0 votes
Here's the log file content: SQL Backup log file 5.3.0.178 -SQL "BACKUP DATABASE [MonitorMedios] TO DISK = 'E:\BackupSW\<AUTO>.sqb' WITH COMPRESSION = 1 " ERRORS AND WARNINGS 6/17/2008 11:11:49 AM: Backing up MonitorMedios (full database) to: 6/17/2008 11:11:49 AM: E:\BackupSW\MonitorMedios_20080617_111149.sqb 6/17/2008 11:16:51 AM: Error 880: BACKUP DATABASE permission denied in database: (MonitorMedios) 6/17/2008 11:16:51 AM: Timeout expired / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Database Permission Denied
Here's the log file content: SQL Backup log file 5.3.0.178 -SQL "BACKUP DATABASE [MonitorMedios] TO DISK = 'E:\BackupSW\<AUTO>.sqb' WITH COMPRESSION = 1 " ERRORS AND WARNINGS 6/17/2008 11:11:49 AM...
0 votes
Where's the script SQL Backup uses for backup rights? do you mean runing the backup script SQL Backup creates for backing up the conflicting database? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Database Permission Denied
Where's the script SQL Backup uses for backup rights? do you mean runing the backup script SQL Backup creates for backing up the conflicting database?
0 votes
Yes, using the same user i can make backups of both databases in Enterprise manager or SQL Management Studio, I also made a trace from another database backup made with SQL Backup to verify it effectivily made it with the same user and it does / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Database Permission Denied
Yes, using the same user i can make backups of both databases in Enterprise manager or SQL Management Studio, I also made a trace from another database backup made with SQL Backup to verify it effe...
0 votes
Total activity
16
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2