Link Server with a Specific Name ARCHIVE -> MyDB03 ARCHIVE is the link server name. MyDB03 is the actual database server name. Sources: https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-2017
The first RPC setting is mainly for a legacy feature called Remote Server, which is documented here. http://msdn.microsoft.com/en-us/library/ms190187.aspx You probably will not be using remote servers in SQL Server 2005 -SQL Server 2014 versions. If you do happen to use “remote servers”, the RPC setting enables a certain security feature. Sources:
Data type Comments Time Only keeps track of nanoseconds in a day. There is no reference to a date.Is stored using between 3 and 5 bytes. Date Only keeps track of days, starting 01/01/01 to 31/12/9999.Takes 3 bytes for storage. SmallDateTime Can be used to store dates between 01/01/1900 and 06/06/2079.Also allow to keep track... » read more
Error: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\Summary.txt If we look at the start place of the error, it says System.Security.Cryptography.CryptographicException. This means that there are some issues while encryption of the data. And the real error message is “The requested operation cannot be completed. The computer must be trusted for delegation and the current user account... » read more
First setup a link server to the other database.
Microsoft Visual Studio Community Edition (Free) has a tool called Data Compare and Schema Compare. Visual Studio -> Tools -> SQL Server Red-Gate http://www.red-gate.com/products/sql-development/sql-compare/ http://www.red-gate.com/products/sql-development/sql-data-compare/
Transactional Replication Configuration is not that easy. Replication is always table level. Lot of maintenance work. There is a latency and latency may increase in busy system. Need to configure it for each table. Not a high availability option.You can use it as a DR strategy. AlwaysOn High Availability and Disaster recovery strategy.Built on top of Windows Failover Clustering... » read more
SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server. An availability group supports one set of primary databases and one to eight sets of corresponding secondary databases. Each set of availability database is hosted by an availability replica. Two types of availability replicas exist: a single primary replica. which hosts the primary databases, and one... » read more
Error: The filegroup ‘xxxxxx’ cannot be removed because it is not empty. Fix: Remember to remove the partition the filegroup belongs to.
ALLOW_PAGE_LOCKS = { ON | OFF }Applies to: SQL Server 2008 through SQL Server 2017. Specifies whether page locks are allowed. The default is ON. ONPage locks are allowed when accessing the index. The Database Engine determines when page locks are used. OFFPage locks are not used.