Viewing 15 posts - 30,751 through 30,765 (of 39,823 total)
Please let us know if you find anything.
Has the server been rebooted?
The server does get recovered every time and it's possible if there were lots of changes that needed to...
November 19, 2007 at 8:29 am
Please let us know. I never checked before, but I wouldn't be surprised if some process is using temp space as temporary storage. I'd expect them to clean up, however.
Are...
November 19, 2007 at 8:26 am
Recovery is the process of rolling forward and rolling back when a database starts. It is different from the recovery model. The advice above (both) is what you would follow...
November 19, 2007 at 7:44 am
The database restore would trigger a DDL event since there is essentially a new database being created (and one being dropped).
November 19, 2007 at 7:41 am
You have to re-run the restore and use the WITH NORECOVERY or STANDBY options during the restore.
November 19, 2007 at 7:38 am
You should have a primary key in any case. Even a surrogate to allow you to get to every row.
November 19, 2007 at 7:36 am
Brendan,
I don't think this will help you. SPs typically aren't "upgradeable". Usually you can try to uninstall, but often you have to remove SQL Server, reinstall, then reattach your dbs....
November 19, 2007 at 7:34 am
I haven't seen this. Unless there were some transaction that prevented access to a table, I don't know what would take so long.
I'd reboot the server to clear it if...
November 19, 2007 at 7:30 am
I don't think employers have to promote general welfare. It was a benefit the unions forced and companies started to offer to compete for workers.
With the way healthcare is changing...
November 19, 2007 at 7:26 am
Are you not backing up to different files each day? Going to the same file is a bad idea.
If you use different files, set a script, prob VB or Powershell,...
November 16, 2007 at 12:40 pm
I have no idea, but I'd call PSS. Something is wrong here and you don't want to be running without the ability to backup or recover.
It's worth the $250.
November 16, 2007 at 12:38 pm
Something definitely happened. Either someone did a load, index rebuild, some activity that moved lots of pages around.
November 16, 2007 at 12:37 pm
Andras is correct. What happened is the customer had two files specified in the backup dialog and ended up with a "striped" backup, with both files containing part of the...
November 16, 2007 at 12:34 pm
It sounds like a file conflict.
Can you manually restore the file.
November 16, 2007 at 12:33 pm
Viewing 15 posts - 30,751 through 30,765 (of 39,823 total)