Viewing 15 posts - 36,886 through 36,900 (of 39,720 total)
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
You can use dbcc checkident to reset the identity. This could have happened.
To fix things, find the max value and ensure the identity seed is set here. Then you can...
October 31, 2002 at 11:34 am
Windows Auth won't transit most firewalls if they are setup securely. Windows Auth requires the NetBIOS ports.
Either use SQLAuth or setup a VPN like tunnel from your DMZ to the...
October 31, 2002 at 11:31 am
A good solution. I do something similar. I can snag the servername from the local server in some pacakges.
Not so smooth in SQL 7, but works great in sQL 2000
Steve...
October 31, 2002 at 11:25 am
You cannot create a parameter from multiple parts in the stored procedure call. You have to build it ahead of time. Architectural limitation.
Steve Jones
October 30, 2002 at 5:30 pm
Also, are you restoring over an existing db or a new db?
Steve Jones
October 30, 2002 at 5:21 pm
Check the physical sqlsrv.exe version in the file system.
Updated another server that had been updated with MS02-45 and had no issues. Show .679 as the version. Will do more servers...
October 30, 2002 at 12:07 pm
Viewing 15 posts - 36,886 through 36,900 (of 39,720 total)