Browse by Tags

SQL Server Replication - resolving too many snapshots issues?

Published 15 April 8 6:15 AM | SSQA.net

In case you have many snapshots generated within your Replication setup and having troubles in finding what kind of scheduled job is running during the time of snapshot publication. By default you coudl take help of system catalog MSsnapshot_agents and...

Filed under: sql server, replication, snapshot, sqlagent, script, publisher, tsql, schedule

Replication FAQ - how to know Distributor and Publisher with scripts

Published 19 February 8 4:45 PM | SSQA.net

A newbie set of question that how to know the whether the current server is distributor or publisher? Any pre-defined script to know any other publishers that are using as Distributor? Well, there are such pre-defined scripts and stored procedures are...

Filed under: sql server, replication, snapshot, script, merge, publisher, transactional, distributor, schedule

SQL Server replication FAQ and important measures to consider when replication performance is sufferred

Published 7 February 8 9:41 AM | SSQA.net

Here we are going to highlight the majority of tasks you need to perform whenever user complains or you observe about SQL Server Replication performance is affected, adversly. For any performance tuning issues there will be other factors involved including...

Filed under: sql server, performance, replication, snapshot, best practices, agent, publisher, subscriptions, FAQ, schedule

SQL Server Replication - presentation from Scottish Area SQL Server User Group

Published 12 December 7 4:4 PM | SSQA.net

As a part of regular monthly meetings from Scottish Area SQL Server user group [ Scottish Area SQL Server User Group: Wednesday 12th December 18:30 - 21:00 : Edinburgh ] I have given a presentation on SQL Server Replication, type of SQL Server Replication...

Filed under: sql server, microsoft, replication, snapshot, best practices, merge, transactional, beginners, types

Replication FAQ series - Which columns are published in snapshot or transactional or merge publications in this database?

Published 11 December 7 6:48 PM | SSQA.net

Here is script you can find which columns are published in the replication that is using either snapshot or transactional or merge publications. --For snapshot or transactional publications select object_name(object_id) as tran_published_table, name as...

Filed under: sql server, replication, snapshot, merge, transactional, tsql, tables, columns, FAQ

Error message when you create a snapshot backup of many databases at the same time in SQL Server 2005: "ERROR Selected writer 'Microsoft Writer (Service State)' is in failed state"

Published 21 October 7 12:57 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Error message when you create a snapshot backup...

Filed under: sql server, database, error, kba, snapshot, service state, writer

FIX: Error message when you set up a snapshot publication on a database in SQL Server 2005: "Error 137, Must declare the scalar variable <VariableName>"

Published 12 October 7 6:5 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, error, kba, variable, snapshot, publication, 137, scalar, declare

FIX: Error message when the Distribution Agent tries to apply the snapshot to the subscriber in SQL Server 2005: "Must declare the scalar variable "@Variable""

Published 20 August 7 2:44 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when the Distribution Agent...

Filed under: sql server, kba, variable, snapshot, subscriber

When to use mirrored server as a reporting server?

Published 8 August 7 3:9 AM | SSQA.net

IN the case of production server which is running 24/7 and can't afford any downtime, it is good to keep the mirrored server for reporting purpose. Say if the requriement is to have r eporting server that should be updated with data from production...

Filed under: sql server, snapshot, database mirroring, reporting services

SQL 2005 snapshot backups and disk space monitoring

Published 13 June 7 5:20 AM | SSQA.net

When using SNAPSHOT backups in SQL Server there are few things you need to consider, that included monitoring the disk space usage where the database backups & snapshot files are stored. BOL confirms about SNAPSHOT backups as: The underlying backup...

Filed under: sql server, backup, snapshot, disk space

Snapshot backups - do I need equivalent database size disk space?

Published 23 May 7 3:17 AM | SSQA.net

Snapshot backups are introduced in SQL Server 2005 version that uses: The underlying backup technology creates an instantaneous copy of the data that is being backed up. The instantaneous copying is typically accomplished by splitting a mirrored set of...

Filed under: sql server, performance, backup, database, disk, space, snapshot