Viewing 15 posts - 166 through 180 (of 236 total)
I do it all the time, saves about 50 % dasd.
Never seen a problem, although I have heard of problems taking a .Bak, zipping it, transfering it, then restoring it.
KlK,...
April 29, 2003 at 9:11 am
Also make sure those backups, full/diff/logs get moved OFF that server ASAP.
I would also look at designing the DB with replication in mind, maybe you won't use it initially, but...
April 3, 2003 at 7:19 am
I used the Rebuild registry option.
If it is the same problem I had, you should be able to unlock the following registry keys "HKEY_LOCAL_MACHINE\Software\ODBC\odbc.ini" and
its subkeys.
KlK, MCSE
March 27, 2003 at 12:18 pm
Ditto with Antares.
You can even move the MDF's and attach.
KlK, MCSE
March 26, 2003 at 7:50 am
Well I'll try and keep this breif. I am heavily involved in SQL Server and UDB on the FP (Fischer Price) platforms (just a joke the MainFramers tease us...
March 25, 2003 at 2:05 pm
Well this note was for Andy,
The issue is deleting historical data at the publishers, but not at the subscriber.
The process is creating historical data at each server to allow...
March 25, 2003 at 12:39 pm
Andy, in researching another problem, but I've been meaning to find / respond.
I solved the issue of having deletes at the remote site, not be applied to the central site....
March 23, 2003 at 5:09 pm
No, I don't. My rule is backup (I want a backup, better a bad backup than NO backup), integrity check, then reorgs. So I do not include it...
March 20, 2003 at 8:44 am
Well I solved it, although I would like to know the easy way to fix the problem.
Apparently one of the other techs is playing with DB2/UDB v8 and installed something...
March 19, 2003 at 10:27 am
Somewhere in this thread I had the same problem. At the publisher, click on configure publishing .... Somewhere in there is a list of valid servers !!!
KlK, MCSE
March 18, 2003 at 12:05 pm
Here's a trick.
Server one, seed the identity field at 1000, increment 2. Server 2 seed the identity field 1001, increment by 2.
No more conflicts.
If you have more sites possible,...
March 18, 2003 at 12:03 pm
What type of errors are you getting ?
I restore 7 to 2k all the time, we are migrating slowly to 2k, and I have to restore them for testing. ...
March 17, 2003 at 8:51 am
Answer to your second question.
Rowcount in system tables is not gauranteed to be accurate.
I use it all the time though, as it is much faster.
It is...
March 7, 2003 at 9:01 am
We had that problem, but it had blobs. MS recommended turning on Traceon 1180 (?). But it is specifically related to Blobs.
KlK, MCSE
February 25, 2003 at 7:52 am
Viewing 15 posts - 166 through 180 (of 236 total)