Comments
Sort by recent activity
I think your missing a comma after the password.
WITH PASSWORD=''fjfelejl'' , / comments
I think your missing a comma after the password.
WITH PASSWORD=''fjfelejl'' ,
Hi Pam,
Unfortunately there is not currently a way to restore multiple databases using the GUI.
There is a existing feature request you may want to vote for. https://sqlbackup.uservoice.com/forums/ ... -databases
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
You can write a dynamic SQL script to restore multiple databases.
See the following thread for some examples. http://www.red-gate.com/messageboard/vi ... hp?t=16041
Sincerely,
Manfred / comments
Hi Pam,
Unfortunately there is not currently a way to restore multiple databases using the GUI.
There is a existing feature request you may want to vote for.https://sqlbackup.uservoice.com/forums/ ...
Hi JackAce,
The order of the data script is pretty much random. The tool was not designed to create scripts that could be read by a diff tool.
There is an existing feature request under the internal reference number of SDC-1134 to make the scripts order more consistent so they can be handled better by diff tools.
I will add your details to the existing request.
Manfred / comments
Hi JackAce,
The order of the data script is pretty much random. The tool was not designed to create scripts that could be read by a diff tool.
There is an existing feature request under the interna...
Hi Benjamin,
I was able to reproduce the reported behavior and have logged this issue under the internal reference number of SP-5038.
Unfortunately I am unable to provide a definitive timeline for when this might be fixed.
Sorry for any inconvenience this may have caused.
Sincerely,
Manfred / comments
Hi Benjamin,
I was able to reproduce the reported behavior and have logged this issue under the internal reference number of SP-5038.
Unfortunately I am unable to provide a definitive timeline for ...
Hi Shuaib,
SQL Doc provides a command line interface so that you can generate database documentation from the command line or in script or batch files.
Here is documentation on using the SQL Doc command line. http://documentation.red-gate.com/displ ... mand+line#
Sincerely,
Manfred / comments
Hi Shuaib,
SQL Doc provides a command line interface so that you can generate database documentation from the command line or in script or batch files.
Here is documentation on using the SQL Doc co...
Hi Raj,
Sorry you are having such a difficult time with the tool.
Ideally each forum thread should only pertain to one issue.
Since it appears that you are having multiple issues.
I suggest you open an offical support request by sending the details of your issue to support@red-gate.com
Manfred / comments
Hi Raj,
Sorry you are having such a difficult time with the tool.
Ideally each forum thread should only pertain to one issue.
Since it appears that you are having multiple issues.
I suggest you ope...
Hi Raj,
The error you are receiving indicates that the login failed for the SQL Server instance.
Has the sa password changed since installing the server components on the server?
Can you try running the following on your SQL Server?
EXECUTE master..sp_addextendedproc sqbsetlogin, 'xp_sqlbackup.dll'
EXECUTE master..sqbsetlogin 'sa', 'yourpassword'
EXECUTE master..sp_dropextendedproc sqbsetlogin http://documentation.red-gate.com/displ ... +for+user# / comments
Hi Raj,
The error you are receiving indicates that the login failed for the SQL Server instance.
Has the sa password changed since installing the server components on the server?
Can you try runnin...
Hi Raj,
Sorry you are experiencing this.
The error you are receiving is likely because the SQL Server Compact Database we use to hold the backup history information has hit the maximum size allowed: "The database file is larger than the configured maximum database size."
The simplest way to get the tool working again is to stop the backup service on the server issuing the warning, rename the data.sdf file, and then start the service again. This will create a new file.
This file is located on the server in the following location:
C:\ProgramData\Red Gate\SQL Backup\Data\instance_name
Do you know how much history you're keeping? It's unusual for the DB to hit the maximum size, so maybe you haven't set it to ever delete any history. You can set the amount of history to delete in the File Management options of the server. http://documentation.red-gate.com/displ ... t+options#
Alternatively you can use script in the following knowledge base article to manually delete the history. http://documentation.red-gate.com/displ ... +manually#
Sincerely,
Manfred / comments
Hi Raj,
Sorry you are experiencing this.
The error you are receiving is likely because the SQL Server Compact Database we use to hold the backup history information has hit the maximum size allowed...
Objects with rows that can not be matched automatically are shown in the Tables or views that could not be compared group. To match rows in the two data sources, SQL Data Compare requires:
•a comparison key for each table or view
•mappings between objects in the data sources
In some cases, SQL Data Compare is unable to map objects and select comparison keys automatically. http://documentation.red-gate.com/displ ... +compared#
You may need to set a custom comparison key or manually map the object. http://documentation.red-gate.com/displ ... arisonkeys http://documentation.red-gate.com/displ ... g+objects# / comments
Objects with rows that can not be matched automatically are shown in the Tables or views that could not be compared group. To match rows in the two data sources, SQL Data Compare requires:
•a ...