Gerard Silveira (6/3/2013)

---

Can you shed some light on why the transaction log was huge in the first place ?

Also wont it grow back to its original size once the effects...

GilaMonster (6/3/2013)

---

Patience.

We're volunteers, we all have our own jobs, our own problems and we post in our spare time. If you want immediate solutions hire someone, it's not as...

Well, since no one bothers to answers this question.

I posted my only solution here: I have to shrink the t-log file on the principal partner of this mirroring pair on...

Just some quick answers:

EXEC sp_MSforeachdb

@command1='use [?]; if db_name() not in (''master'', ''model'', ''tempdb'', ''msdb'', ''distribution'') select * from information_schema.schemata'

go

Although this is an old thread, but I am encountering the same problem again today.

Eventinfo "WAITFOR (RECEIVE message_body FROM WMIEventProviderNotificationQueue), TIMEOUT 5000" from spid 51 in msdb dabase is executing...

yes, this instance has email profile configured.

And this is the output of DBCC inputbuffer

EventTypeParametersEventInfo

Language Event0WAITFOR (RECEIVE message_body FROM WMIEventProviderNotificationQueue), TIMEOUT 5000

Srihari Kagita (11/29/2012)

---

Verify the SQL Server service and make sure its running under Administrator Accounnt.

Example:

I just completed installing SQL Server 2012 on one of our test server with NT...

christopher_l_conner (10/10/2012)

---

What a lifesaver. Hyperbac was causing the same issue in a prod environment that was recently handed to me. Couldn't restore to reporting server. You saved...

Without "rollback immediate" didn't work either.

I've since also tried restart the sql server...

I think I've found the cause and it has something to do with RedGate's hyperbac.

I've recently taken over this SQL2000 server and hyperbac was installed beofre I came in.

Today I...

Very native, directly from SQL Server Enterprise Manager.

Thanks for your reply first of all.

But please do read carefully about my question, I am trying to restore a backup from SQL2000 to an instance running SQL2008R2, it is...

And I also tried to run "restore verifyonly from disk = <UNC_location_of_original_sql2000_backupfile>" from SQL2008R2 server to a network UNC location (after properly assign the service account's access privileges), but got...

I've tried to run "restore verifyonly from disk = <backup_file_location>" on both 2000 and 2008R2 instances and got the following messages:

on SQL2000

The backup set is valid

on SQL2008R2 x64

The media family...

By 'connected', you mean SAN?

Mount points are administered in my company by windows...