Hi All,

Thanks for the great replies. Unfortunately we cannot use replication because the tables in our database do not have primary keys. This came out of the box...

Hi,

I am faced with this exact scenario. In doing some research I see that new snapshots need to be created and I was wondering the same thing...how to get...

Thank you Todd! I will pass this onto my sysadmin!! 😀

Hi,

Yes, that is in the works as we speak. I have applied SP3 to 3 other servers and working up to apply it to our production server sometime in...

Hi,

Thanks for the reply. Yes, both WMI and IIS were checked....stopped/restarted....uninstalled/installed. Still get the same error. :blink:

Isabelle

I actually got that result too:

1899-12-31 00:00:00.000

Hi Murthy,

One of the transaction logs was corrupted. I ran the RESTORE VERIFYONLY on the last log that it was trying to restore and I got a message that...

Hi,

But wouldn't WITH REPLACE just be restoring the database from a backup of production and it will just restore over the existing one? To do a complete restore from...

Hi,

Yes, I considered replication but was under the impression that it requires a seperate license so that's why I was thinking about log shipping. I already have it setup...

Hi all,

I thought rebuildm.exe was retired in 2005? When I ran through my backup/recovery testing I did the following:

1) Stop all the SQL services

2) put SQL in single user...

Well that's why I was asking my first question about backing up the log and shrinking it? If SQL 2005 automatically moves the active portion then why was it...

Hi,

Thanks for the link. I see that even though the log had most of the space free that the active portion of the log must have been at the...

Im just curious as to why don't you just backup the log and shrink the file since this is in full recovery mode? this is under the understanding that...

Thanks Colin. I will do that.

Isabelle

TheSQLGuru (9/18/2008)

---

Colin brings up a good point. Have you verified that your memory configuration is correct given that you have 32 bit sql server EE with a large-ram box?...