Posts
Sort by recent activity
Upgrade to 2016 SP 1 - Restores don't work anymore
Hello
We have upgraded to SQL Server 2016 SP 1 and SQL Backup version 8
when we run the restores, they fail with the following message.
Executed as user: XXXXX SQL Backup failed with exit code: 89...
Unable to Restore ndf to different drive letter
Hello,
I have 1 Server with two SQL Server Instances installed. I am trying to restore the same SQL backup to each instance. The backup comes from a different server (production). The database...
NDF files not restoring to their original name
Hello,
The scenario is as follows:
I want to restore a database from the production server to the staging server
The database exists on the staging server
The drive letters and file structures ob b...
Restore to a different server failing
Hello,
I have a created a restore job to restore a production server to a staging server. The jobs are failing, but i cant find a log file or a reason why. I also can not send email for the resto...
Compare Tables within the same database
Hello,
We have implemented some logical partitioning (same table multiple times) within our databases - I need to keep their definition's in sync. It would help if we could link/create match pairs...
SQL Prompt Use DatabaseName not in alpha order
Hello,
When I type Use and the database name prompts appear they don't appear in alphabetical order - they appear in some other order (not sure what the order is - maybe created date?). Is there a...