Viewing 15 posts - 18,196 through 18,210 (of 39,903 total)
I think you're confused a little on log shipping.
The way log shipping works on the primary
- Make a full backup
- Make log backups
- Make periodic full backups
It just runs.
On the...
September 17, 2010 at 10:14 am
It could. There's a lot of different ways that SANs work. You can contact your vendor, but if the drives aren't set for dynamic expansion, you might need to bounce...
September 17, 2010 at 9:19 am
To update a database, attach (or restore) the files on the higher version server. If you are looking to upgrade your entire instance, then run the Upgrade Advisor, and then...
September 17, 2010 at 9:16 am
September 17, 2010 at 9:13 am
I don't want a cookie. Not really my thing.
Now this....

September 17, 2010 at 9:12 am
Why not take your full backup and restore it on the remote instance? Depending on activity, the VSS service can be problematic. You are attempting to freeze two files and...
September 17, 2010 at 8:58 am
All good suggestions. ultimately you cannot start a remote job from your local SQL Server instance without opening a connection on the other instance. Your instance has no control over...
September 17, 2010 at 8:55 am
If you don't need this in a single transaction, you can try updating batches of rows. Sometimes that is quicker than one large update.
September 17, 2010 at 8:53 am
Can you post the error?
September 17, 2010 at 8:51 am
CirquedeSQLeil (9/17/2010)
But what does the null represent?
Mean editor?
September 17, 2010 at 8:45 am
Too slow! Removing a lot of SPAM this morning, and disabling some accounts.
September 17, 2010 at 8:35 am
I believe when you run this that the SQL Server service account might need rights to the destination.
September 17, 2010 at 8:29 am
Alvin Ramard (9/17/2010)
I'm happy to see that nobody has repsonded to that sock puppet post.
Removed. Not likely to get responses now.
September 17, 2010 at 8:21 am
Merge or Bidirectional transactional will help. However you might end up spending a lot of time trying to resolve conflicts and issues. Are you talking about moving some tables and/or...
September 17, 2010 at 8:16 am
Viewing 15 posts - 18,196 through 18,210 (of 39,903 total)