Updatable Subscriptions Deprecated in SQL Server 2012
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
4,022 reads
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
4,022 reads
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
1,992 reads
There's nothing more I love than free food and SQL Server, no joke. I take my free food and SQL...
2011-09-14
522 reads
To troubleshoot replication agent failures, replication agent profiles can be configured to output verbose agent logs to a text file. ...
2011-08-24
4,123 reads
Did you know a snapshot can be applied using the Distribution and Merge Agent –AltSnapshotFolder parameter? This means that after...
2011-08-03
511 reads
When administering Merge Replication, sometimes we need to mark foreign
key constraints NOT FOR REPLICATION. In some cases, we might...
2011-07-29
7,568 reads
Brad McGehee over at SQL Aloha posted his July Question: What Do You Think are the Most Common DBA Pain...
2011-07-02
850 reads
When configuring Merge Replication for Web Synchronization it's common to encounter the error The Proxy Auto-configuration URL was not foundand
...
2011-06-23
1,269 reads
Have you made the mistake of dropping your distribution database like this?
If so, remember not to do this ever again. ...
2011-05-28
1,977 reads
One caveat that’s worth mentioning is replicating the XML data type in
SQL Server using Merge Replication. Sometimes, when replicating...
2011-05-20
1,369 reads
By James Serra
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
By DataOnWheels
The 14th annual Ability Summit is a global event that I attended a few...
Comments posted to this topic are about the item The Journey to Change
Comments posted to this topic are about the item Check Azure SQL DB Space...
Comments posted to this topic are about the item The Cloned Database Size
I have a small test sandbox database on an instance with default master, model, msdb, and tempdb settings. The database has these files:I now run this command:
DBCC CLONEDATABASE(sandbox, sandbox_clone); GOWhen I examine the database file properties, what do they show? See possible answers