Forum Replies Created

Viewing 15 posts - 106 through 120 (of 528 total)

  • RE: Transactional replication of views

    Perhaps this response will help with your question.

    1. Data is stored in tables.

    2. Views display data stored in tables.

    How do you intend to 'replicate' (not 'remotely view') a...

  • RE: Restoring Database

    Prasad -

    The question you pose is one that usually comes up in evolving SQL Server environments. The answers you've received are solid answers to help you with fixing...

  • RE: LTO Compatibility

    Can you check with the vendor of the LTO2 tape drive? Looking at tape descriptions, there seems to be a difference only of capacity. But without having the...

  • RE: Full backup is not overwriting?

    if you execute your script in a windows command window (a la DOS), using sqlcmd, do you get the same results, or does it properly overwrite? If using sqlcmd...

  • RE: Backup database?

    Yulichka -

    you can approach this as a piecemeal task, focusing on the easy parts to capture - creating backup files, moving backup files, restoring them on other servers -...

  • RE: Please help , read the trn files names from a folder

    The executed command must have a fully qualified file name, either UNC or relative drive (e.g., C:\...) if a local file. You may not be formatting your command correctly...

  • RE: A pull subscription to a Snapshot Publication (SS2005)

    You state that the 'Snapshot of Views' is updated daily. IF this is true, then the snapshot should be at the Publisher except for the moment that he's refreshing...

  • RE: Please help , read the trn files names from a folder

    What is the 'additional' cost of simply using NORECOVERY for all of the log files, and then adding a line at the end (similar to a musical coda) which sets...

  • RE: Why can't I restore across a VPN?

    Not to mention that a shared SAN would defeat some of the design principles behind establishing a disaster recovery site. :w00t:

  • RE: Why can't I restore across a VPN?

    Adam Bean (9/4/2008)


    Does the account running SQL have access to the remote drive?

    Adam, yes, the account has full rights. There was a question whether I was using integrated security...

  • RE: How to initiate, and then remove, replication

    I'm reminded of old science fiction tv shows where the all-knowing computer responds 'insufficient data'. I agree that what you're describing is a merge replication scenario. However, some...

  • RE: sp_replicationdboption throwing error

    I don't mean to sound offensive, and apologize if this seems too easy: Do you have the name correct? Is it possible that the name you are using...

  • RE: duplicate server names

    As I understand you, because two different franchises use the same server name, you are unable to set up replication with BOTH of them. But to change the name...

  • RE: No backup file, only mdf and ldf!

    Would there, anywhere, be an image backup of the system? That may have copied the old database in a 'pristine' state, although since this sounds like a non-production machine,...

  • RE: Restore with no data

    The 'brute force' or 'inelegant' way of solving your problem is to copy your backup to a second version of the db on the 2000 server, delete all data...

Viewing 15 posts - 106 through 120 (of 528 total)