Viewing 15 posts - 106 through 120 (of 528 total)
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...
September 25, 2008 at 1:16 pm
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...
September 25, 2008 at 12:58 pm
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...
September 25, 2008 at 12:45 pm
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...
September 25, 2008 at 12:40 pm
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 -...
September 25, 2008 at 12:34 pm
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...
September 22, 2008 at 3:42 pm
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...
September 22, 2008 at 1:41 pm
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...
September 22, 2008 at 12:31 pm
Not to mention that a shared SAN would defeat some of the design principles behind establishing a disaster recovery site. :w00t:
September 5, 2008 at 11:59 am
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...
September 5, 2008 at 9:07 am
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...
September 4, 2008 at 9:17 am
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...
September 4, 2008 at 9:11 am
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...
September 4, 2008 at 9:06 am
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,...
August 26, 2008 at 2:27 pm
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...
August 26, 2008 at 2:25 pm
Viewing 15 posts - 106 through 120 (of 528 total)