Here's my predicament. I changed the filter on an article within a subscription, but not in a meaningful way. I just added "database.dbo." before a column name, but now my subscription is flagged for reinitialization, and won't replicate any transactions unless I start over with a new...
I just had the exact same need (using snapshot repl), and couldn't find a way to just drop 1 "article" (table) from the publication so I could change one of the fields. After a little poking around, I came up with this plan to drop a table from a publication so it can be modified...
The network admin does the restores because he controls the network backups & tape devices. I can work with my own backups to drives, but don't have disk space to store a backup of the production database.
We're using Veritas ........ I'm sure it has scheduling capability. We don't do these...
I don't have any reliable downtime for the production database .... (there are night jobs that run on various schedules) so I can't detach it and copy the MDF or LDF. The test server is generally used only 9-5. I thought the Transfer DB option would allow a refresh without having to bother...
Every few weeks we need to copy our production database (call it PROD_DB ) on Server#1 and overlay our test database with current data (call it TEST_DB) on Server#2.
We've been restoring from a SQL Agent tape backup to the test database ..... works fine, but I'm dependant on the Network Admin...
I'm learning replication (snapshot for now) and was trying filtering & got strange results. (SQL 2K sp2)
Publisher: Table1
FieldA
FieldB
FieldC
Subscriber: Table1
FieldA
FieldB
FieldC
But now, I decide after the fact to filter FieldC. The subscriber Table still has 3 fields, but the...
Could be that you have invalid data in your Excel file, such as a month GT 12, or day GT 31 ....... SQL verifies that your data is "legal" if it's going into a date field. Maybe if you first import into a work table with a character field, then you can do clean-up, then DTS to your...
When running the create publication wizard, I get:
"Error 14294 - Supply either @Job_id or @Job_Name to identify the job"
I had pubs & subs set up, but things were erroring, so I tried deleting everything and wanted to start from scratch, but the last step in the wizard gets me...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.