Home Forums SQL Server 7,2000 Backups Can't access data from database restored from backup if not sysadmin RE: Can't access data from database restored from backup if not sysadmin
ranadip.dey
Old Hand
Points: 376
More actions
June 17, 2015 at 4:33 am
#1806009
To avoid this issue add your user ( the user who is taking backup) as a user of the Backup database, and your user should have (login) access in the new instance.