|
Home > Archive > MS SQL Server > March 2006 > A weird maintenance problem.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
A weird maintenance problem.
|
|
| Shawn 2006-03-27, 11:23 am |
| I have a small database that is causing my maintenance plans to hang. There
are no errors logged and it does not eventually quit, it just hangs. If I
rename the database, it works fine, but then fails again when named back. I
dropped the db and looked in Master and msdb, but found no references to the
database name (at least in the few sys tables I looked in). Any ideas???
| |
| Ben Nevarez 2006-03-27, 1:23 pm |
|
Send more info about the problem. If the database fails only with a
specific name, what this name is? Which version of SQL Server? Which
activities are you doing in your maintenance plan? Check on your log to see
which activity and database is hanging (log shows messages like dbcc
checkdb(db), Database backed up: Database: db, etc).
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn" wrote:
> I have a small database that is causing my maintenance plans to hang. There
> are no errors logged and it does not eventually quit, it just hangs. If I
> rename the database, it works fine, but then fails again when named back. I
> dropped the db and looked in Master and msdb, but found no references to the
> database name (at least in the few sys tables I looked in). Any ideas???
>
>
>
| |
|
| Thanks, but I think I got it. I rebuilt the database and then had to restart
SQL to clear something (I don't know what) out of memory. Now it works fine.
"Ben Nevarez" < BenNevarez@discussio
ns.microsoft.com> wrote in message
news:9686B3F0-4AD7-4A46-A332- 5717AB97EE07@microso
ft.com...[color=darkred]
>
> Send more info about the problem. If the database fails only with a
> specific name, what this name is? Which version of SQL Server? Which
> activities are you doing in your maintenance plan? Check on your log to
> see
> which activity and database is hanging (log shows messages like dbcc
> checkdb(db), Database backed up: Database: db, etc).
>
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
>
> "Shawn" wrote:
>
|
|
|
|
|