Viewing 15 posts - 3,841 through 3,855 (of 6,216 total)
July 9, 2002 at 9:17 am
You have to figure it out by adding up which bits are set:
4 = select into/bulkcopy; set with sp_dboption.
8 = trunc. log on chkpt; set with sp_dboption.
4194304 = autoshrink.
Andy
July 9, 2002 at 9:16 am
July 9, 2002 at 8:05 am
I think that means you're trying to create a duplicate key.
Andy
July 9, 2002 at 5:49 am
Then without switching recovery modes your best bet is to delete the records in reasonable sized chunks. Depending on your log size, I'd say anywhere from 10k to 100k records...
July 9, 2002 at 4:59 am
I made a batchfile containing this:
xcopy C:\test1\*.* c:\test2\*.*
And then ran this:
xp_cmdshell 'c:\testxcopy.bat'
Which worked without error, copying the file and giving this output:
NULL
C:\WINNT\system32>xcopy C:\test1\*.* c:\test2\*.*
C:\test1\test1.sql
1 File(s) copied
NULL
Andy
July 8, 2002 at 6:16 pm
July 8, 2002 at 6:12 pm
July 8, 2002 at 5:25 pm
Im for loose coupling, but I think from what you've described rolling them up makes sense, dont know that I'd add the extra layer Steve suggests - but it's worth...
July 8, 2002 at 5:24 pm
I dont have XP on a machine here to test with. I dont see why it shouldnt work. Basically it detaches, copies, attaches. Check the event log to see if...
July 8, 2002 at 5:19 pm
Havent seen this. Tried reinstalling the client tools? Or profiling to see if anything is really being sent over to the server?
Andy
July 8, 2002 at 1:01 pm
Seems like either merge or transactional with updating subscribers would do the trick pretty well.
Andy
July 8, 2002 at 12:59 pm
July 8, 2002 at 12:55 pm
The delete only happens after the backup is complete. I've got an article I recently posted that goes into more detail. If you need the files deleted first, you'll have...
July 8, 2002 at 12:54 pm
Viewing 15 posts - 3,841 through 3,855 (of 6,216 total)