The number of records being added/deleted/modified today is close to 5000, with approximately 100 of them being updates, 10 being deletes, and the rest inserts.
There were no errors whatsoever reported during the running of my program and I have error reporting built in at practically every step of the way so if something went wrong I would have gotten a log of it. But at the end of the sync, I went into the database to see if it worked, and only the deletes and modifies are reflected in the database right now.
Each insert statement was executed without exception catch. All 4900 or so insert statements were executed first, then the 10 deletes, then the 100 modifies, then the whole thing was committed.
I began the transaction with READ COMMITTED isolation type.
Everything is done in a C# application via OleDbConnection/OleDbCommand/OleDbTransaction.
So I can't figure out why I would have gotten no errors, no exceptions, and some of the statements are visibly reflected in the database after the commit (all of the deletes & updates), and none of the inserts are visible.
It's been about 20 minutes since the commit. Is it possible that it just hasn't finished committing yet? How long could it take if that's the case, and how can I get confirmation when the Commit is completed?
I tried to rename the database and restore a backup and run the sync again to see if I could do some step-through and find any issue, but I get the following error when I try to rename the database:
Quote
TITLE: Microsoft SQL Server Management Studio
------------------------------
Unable to rename [database]. (ObjectExplorer)
------------------------------
ADDITIONAL INFORMATION:
Rename failed for Database '[database]'. (Microsoft.SqlServer.Smo)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030)
------------------------------
Unable to rename [database]. (ObjectExplorer)
------------------------------
ADDITIONAL INFORMATION:
Rename failed for Database '[database]'. (Microsoft.SqlServer.Smo)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030)
Please help. Thank you in advance.