Viewing 15 posts - 36,976 through 36,990 (of 39,818 total)
You can also right click, generate script, and use that.
Steve Jones
November 1, 2002 at 1:38 pm
You are welcome. Meant to be a pair, boot data out and then in on another server.
You can use the interactive bcp import to create a format file. Look it...
November 1, 2002 at 1:33 pm
No, you need a format file.
Steve Jones
November 1, 2002 at 9:49 am
Personally, I dislike Access. Maybe that's an understatement. I hate Access and would like to personally burn a few copies. But Andy brings up a good point, as do most...
November 1, 2002 at 9:43 am
Why did it happen? Failed disk? Internal corruption?
Until you know what caused it, you cannot prevent it.
Steve Jones
October 31, 2002 at 7:01 pm
This isn't a SQL question. I'd post this at 4guysfromrolla or somewhere that is more ASP based.
Steve Jones
October 31, 2002 at 7:00 pm
May want to spot check this every day for awhile and see if anything changes.
Steve Jones
October 31, 2002 at 6:59 pm
for 10 plus years? Not sure hard disk is more reliable than tape.
If you need it? Multiple copies. CDR/DVD and tape. Course, keep in mind, what's the penalty for...
October 31, 2002 at 11:54 am
SQL has a timestamp datatype which is a sequential stamp for the transaction log.
The datetime (from getdate()) in SQL can differ from the OS. It appears that SQL checks around...
October 31, 2002 at 11:51 am
Access is less robust. As far as when to move? When you can afford to or not afford not to.
If you want point in time recovery, more reliable service, scalability,...
October 31, 2002 at 11:48 am
Haven't had issues here.
Steve Jones
October 31, 2002 at 11:44 am
have you set it to "repair minor errors"?
Don't
Steve Jones
October 31, 2002 at 11:43 am
The explanation above is the best, though it's possible some hardware controllers, like RAID cards, may have this cached even though the OS thinks it's written. Most controllers are write-through,...
October 31, 2002 at 11:38 am
Is there a lot of activity on the server? Is this log activity or data activity? Check for writes to the files.
Steve Jones
October 31, 2002 at 11:35 am
Viewing 15 posts - 36,976 through 36,990 (of 39,818 total)