Home
|
Weblogs
|
Forums
|
SQL Server Links
Search:
Active Forum Topics
|
Popular Articles
|
All Articles by Tag
|
SQL Server Books
|
About
SQL Server Forums
Profile
|
Register
|
Active Topics
|
Members
|
Search
|
Forum FAQ
Register Now
and get your question answered!
Username:
Password:
Save Password
Forgot your Password?
All Forums
SQL Server 2008 Forums
Replication (2008)
Backup - Replication
New Topic
Reply to Topic
Printer Friendly
Author
Topic
niks
Starting Member
India
9 Posts
Posted - 06/15/2012 : 03:41:59
Can i take backup while replication is running?
How can i temporary disable replication if i want to change in replicated table structure.
My snapshot agent is not getting start automatically and i have to press manually start, can i schedule it auto.
Thanks & Regards
Niks
Regds
Niks
tkizer
Almighty SQL Goddess
USA
35007 Posts
Posted - 06/15/2012 : 03:43:00
Yes backups are fine and highly recommended!
Depends on what you are changing, but you may not even need to disable it. Lots of schema changes get replicated automatically, started with SQL 2005.
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Subscribe to my blog
niks
Starting Member
India
9 Posts
Posted - 06/15/2012 : 03:48:26
Hey Tara,
Pls help me out in bellow,
Can i take backup while replication is running?
How can i temporary disable replication if i want to change in replicated table structure.
My snapshot agent is not getting start automatically and i have to press manually start, can i schedule it auto.
Regds
Niks
tkizer
Almighty SQL Goddess
USA
35007 Posts
Posted - 06/15/2012 : 03:54:54
I answered it already. ?
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Subscribe to my blog
Topic
New Topic
Reply to Topic
Printer Friendly
Jump To:
Select Forum
General SQL Server Forums
New to SQL Server Programming
New to SQL Server Administration
Script Library
Data Corruption Issues
Database Design and Application Architecture
SQL Server 2012 Forums
Transact-SQL (2012)
SQL Server Administration (2012)
SSIS and Import/Export (2012)
Analysis Server and Reporting Services (2012)
Replication (2012)
Availability Groups and DR (2012)
Other SQL Server 2012 Topics
SQL Server 2008 Forums
Transact-SQL (2008)
SQL Server Administration (2008)
SSIS and Import/Export (2008)
High Availability (2008)
Replication (2008)
Analysis Server and Reporting Services (2008)
Other SQL Server 2008 Topics
SQL Server 2005 Forums
Transact-SQL (2005)
SQL Server Administration (2005)
.NET Inside SQL Server (2005)
SSIS and Import/Export (2005)
Service Broker (2005)
Replication (2005)
High Availability (2005)
Analysis Server and Reporting Services (2005)
Express Edition and Compact Edition (2005)
Other SQL Server Topics (2005)
SQL Server 2000 Forums
SQL Server Development (2000)
SQL Server Administration (2000)
Import/Export (DTS) and Replication (2000)
Transact-SQL (2000)
Analysis Services (2000)
MSDE (2000)
Development Tools
ASP.NET
Reporting Services Development
Other Development Tools
Site Related Forums
Site Related Discussions
Article Discussion
Poll Discussion
The Yak Corral
Other Forums
SQL Server 6.5 \ SQL Server 7.0
Other Topics
MS Access
ClearTrace Support Forum
Old Forums
CLOSED - General SQL Server
CLOSED - SQL Server 2005/Yukon
--------------------
Home
Active Topics
Frequently Asked Questions
Member Information
Search Page
SQL Server Forums
© 2000-2009 SQLTeam Publishing, LLC
This page was generated in 0.05 seconds.
Backup - Replication
Posted - 06/15/2012 : 03:41:59
