Comments
Sort by recent activity
Hi pgrove,
Sorry for my delayed response.
I have been recreating your environment in a test network and have been able to recreate the issue you are encountering.
It seems that this problem has been noted before and occurs because of SQL Server's account impersonation.
Unfortunately we don't have a fix for this and the only workaround is as follows :
Create SQL Server Authentication accounts for your developers on SQLServer1 with the sysadmin role.
Create a AllowSQLBrowsing registry entry of DWORD type and set it to 1 in the following key :
32-bit machines: HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>
64-bit machines: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>
Set the SQL Backup GUI on each workstation to use SQL Authentication for SQLServer1.
More information on this can be found in the help file under Tips>Specifying File Paths.
I hope this help and apologise we don't have a fix for this issue. / comments
Hi pgrove,
Sorry for my delayed response.
I have been recreating your environment in a test network and have been able to recreate the issue you are encountering.
It seems that this problem has bee...
Hi pgrove,
It seems like it's a Logged in Windows User permissions problem.
I can create a test machine, create 2 users : BackupUser and BackupAgent, add both users to the Users group on the SQL Server machine only and assign them both sysadmin rights.
I set the SQL Backup Agent Log On account to BackupAgent and log into Windows as BackupUser.
I then create a shared folder on another test machine, assign both BackupAgent and BackupUser read and write permissions.
Using the SQL Backup GUI I can both use the File Browser to browse the network share and backup to it.
If I deny access to BackupUser to the folder I can no longer browse in File Browser but can backup to it if I specify the Servername\Share directly.
Giving access back to BackupUser and taking it away from BackupAgent, I can now search to network share using the File Browser but can no longer successfully back up to it.
What Windows versions and SQL Server versions are you running?
Are you using Windows or SQL Authentication?
Which machine are you taking the Administrator permissions away from, the developer's machine or the network share?
Also if your SQL Server Service running under the account you are logging in with or different and have these permissions been changed?
Thanks, / comments
Hi pgrove,
It seems like it's a Logged in Windows User permissions problem.
I can create a test machine, create 2 users : BackupUser and BackupAgent, add both users to the Users group on the SQL Se...
Hi pgrove,
Thank you for your post into the forum.
If you paste the location of the backup file directly into the SQL Backup GUI rather than using the File Browser, does it allow you to restore it?
Also, does the account logged into Windows have permissions to the network share?
Thanks, / comments
Hi pgrove,
Thank you for your post into the forum.
If you paste the location of the backup file directly into the SQL Backup GUI rather than using the File Browser, does it allow you to restore it?...
Hi snapperfish,
The easiest way to get the syntax is to go through the Restore Wizard and on the last step click the Script tab, the restore script used will then be displayed and you can copy/modify it.
The basic syntax to restore a full backup over an existing database replacing it is : master..sqlbackup N'-SQL "RESTORE DATABASE [Northwind] FROM DISK = ''C:\Programs\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Northwind.sqb'' WITH RECOVERY, REPLACE"'
When using in an agent job you should add the following error handling : DECLARE @errorcode INT
DECLARE @sqlerrorcode INT
EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE [Northwind] FROM DISK = ''C:\Programs\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Northwind.sqb'' WITH RECOVERY, REPLACE"', @errorcode OUT, @sqlerrorcode OUT;
IF (@errorcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @errorcode, @sqlerrorcode)
END
I hope this helps. / comments
Hi snapperfish,
The easiest way to get the syntax is to go through the Restore Wizard and on the last step click the Script tab, the restore script used will then be displayed and you can copy/modi...
Hi clinford,
Unfortunately yes, I am out of ideas at this point!
Thanks, / comments
Hi clinford,
Unfortunately yes, I am out of ideas at this point!
Thanks,
Hi clinford,
Could you try performing a Native Full and Differential backup and let me know the results?
Also, is it only this database which has the problem?
Thanks, / comments
Hi clinford,
Could you try performing a Native Full and Differential backup and let me know the results?
Also, is it only this database which has the problem?
Thanks,
Hi clinford,
The only other information I can find regarding this error is the effect of snapshot backups taken using ntbackup or something similar as per this Mircosoft kb article : http://support.microsoft.com/kb/903643
Does this apply here?
Thanks, / comments
Hi clinford,
The only other information I can find regarding this error is the effect of snapshot backups taken using ntbackup or something similar as per this Mircosoft kb article :http://support....
Hi clinford,
SQL Server is complaining that a current full backup of your database Viewpoint doesn't exist.
This message can often be caused if the recovery model of your database has been changed to simple and back to full again, often during re-indexing or something similar.
If you take a full backup and immediately take a differential, is it successful?
If it is successful you might want to check for a job that changes the recovery model and modify it to change to Bulk-Logged rather than simple.
I hope this helps. / comments
Hi clinford,
SQL Server is complaining that a current full backup of your database Viewpoint doesn't exist.
This message can often be caused if the recovery model of your database has been changed ...
Nate,
Would it be possible for you to send a SQL Compare snapshot of your database schema and the backup you are comparing against (If it isn't too big) to support@red-gate.com quoting reference F0015522 ?
Thanks, / comments
Nate,
Would it be possible for you to send a SQL Compare snapshot of your database schema and the backup you are comparing against (If it isn't too big) to support@red-gate.com quoting reference F0...
Hi Nate,
Is the Index you are selecting Unique or Non Unique?
When you select the Index and run a comparison in the GUI, what value is on the left of the Row Differences pane?
The column of the Index or your PK?
Thanks, / comments
Hi Nate,
Is the Index you are selecting Unique or Non Unique?
When you select the Index and run a comparison in the GUI, what value is on the left of the Row Differences pane?
The column of the Ind...