Viewing 15 posts - 1 through 15 (of 16 total)
Thanks for the response.
I have rerun the export/import process and this time it created the maintenance plan which I could then reference in a SQL Agent job. I...
April 24, 2017 at 10:55 am
Thanks all for your help with this. Much appreciated
March 6, 2014 at 2:14 pm
Currently there is not an instance to upgrade to SP1; we have to deploy a new database from an SP1 instance from another server so we would be looking to...
March 6, 2014 at 9:20 am
The new SP1 instance would also be production.
I would love to be able to move to SP3 but the implications from a service availability point-of-view make it very difficult to...
February 27, 2014 at 11:12 am
Thanks both for the update. We need to support a 2008 SP1 instance alongside our production 2008 instance and we are not in a position to upgrade the production instances....
February 27, 2014 at 10:40 am
I determined that the error was caused by the system stored procedure that cleans the metadata: sp_mergemetadataretentioncleanup. Running it manually generated the errors that were showing in Replication Monitor.
I managed...
April 25, 2013 at 9:03 am
I doubt any ORM could generate more efficient code than a seasoned DB dev. There's a trade-off between portability and performance.
Plus ça change! I worked for both Oracle and...
August 12, 2012 at 11:41 pm
I agree with the vast majority of both the original article and your comments. I was endeavouring to identify a scenario where the ability to develop code that can be...
August 12, 2012 at 9:57 pm
It completely shut off when I saw "your stored procedures would need to be re-written in order to migrate to MySQL, Oracle or another database" since I think this...
August 12, 2012 at 10:58 am
Resolved the issue with the following process:
Stop the merge agent jobs for the publications:
Set database to single user mode: ALTER DATABASE database SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Ran DBCC CHECKDB...
August 2, 2012 at 8:32 am
Resolved the corruption as follows:
Stop the merge agent jobs for the publications:
Set database to single user mode: ALTER DATABASE database SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Ran DBCC CHECKDB to...
August 2, 2012 at 8:31 am
Thanks for the response.
Wish you had chosed mirroring for HA instead of merge replication , is there particular constraint for going the merge replication way 🙂
So do I. Bandwidth restrictions...
August 2, 2012 at 6:20 am
Thanks again. Given the impact of reinitialising the replication we are proposing to run the repair and then use sp_addtabletocontents to push the missing data from the publisher to the...
July 31, 2012 at 10:21 am
We are using the backup agent for SQL Server with Backup Exec which provides for SQL backup/recover, including transaction logs. However, it does not appear to support page level restore.
The...
July 31, 2012 at 7:56 am
Marvelous - thanks again. I have been using that article as my primary source so I think I am just about there then.
July 10, 2012 at 5:31 am
Viewing 15 posts - 1 through 15 (of 16 total)