Showing related tags and posts across the entire site.
-
Viji Assuming you have a full backup and a latest differential backup at hand, the following article might be helpful. SSMS: How to restore differential backups In summary, using SQL Management Studio to restore differential backup Restore the last full backup with RESTORE WITH NORECOVERY option. Once...
-
Troy, DonorWise 3.4.6 restored a 1GB+ bak file successfully. Total file size (mdf, ldf) restored is more than 2GB. Orphaned users (deleted or obsolete DonorWise users) were skipped. Appreciate you working till the wee hours to resolve the issue(s). Goodbye, DonorWise 3.3, Hello, DonorWise 3.4.
-
Troy Yes, "Login failed for user 'sa'" issue (reported by Merissa) seemed to have resolved as of DonorWise 3.4.4., at least against SQL Server 2005 Express. More observations might be needed against newer SQL Server. As suggested, database restoration using SQL Server Management Studio...
-
No worry, Troy, you can defer the issue for review in a latter date. i'm more than grateful for Tntware to revive and looking forward to future releases. Manual workaround The errors were produced in a testing environment. We might be able to manually remove unresolved orphaned users using SQL Server...
-
i was able to re-create same error on a Windows 10 Pro (64-bit) virtual machine. Attached detailed error. Other observations: Error persisted whether restore bak from Downloads folder or MSSQL backup folder Error persisted regardless of login as sa or Windows Authentication sa password tested ok using...