I restored the database back to 3/16 full but never loaded any logs. I then told the database to recover. Now I can't find the 3/16 transaction logs. Does SQL...

Database was stuck in Restoring state so I ran this

RESTORE DATABASE [Apollo] FROM DISK = N'e:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Apollo\Apollo_db_201103152300.BAK' WITH FILE = 1, REPLACE, RECOVERY, NOUNLOAD,...

We use Tivolli on some of our servers. But that only does a copy. I literally ran these a few mins apart. I'm thinking the first restore process may have...

Ah Crap!

Here's what happend.

I restored using this...

RESTORE DATABASE [Apollo] FROM DISK = N'e:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Apollo\Apollo_db_201103152300.BAK' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10

GO

RESTORE...

Got it! Thanks!

I was scripting out to a new windows each of the options to see where the difference was. That's when i noticed the lack of norecovery at the...

GSquared (3/16/2011)

---

You will definitely need to do the tail log backup before you start restoring, unless you're restoring to a different server/instance, or to a different database name. Otherwise,...

You were right. I was able to get a correct IP from the network team and the install on node-1 and node-2 was green across the board! Now I am...

Great info! Thanks!

So I want to just enter a new virtual sql server name here. However, on the next screen it asks for an IP address. I just made up...

Thanks all. I am going to try and get a better understanding of where the issue is in our system and what can be done to resolve it. Although I...

I did some poking around and discovered IE was in Compatibility Mode. After switching back over to normal mode everything is fine. Sorry for the alarm.

Thanks Steve!

Yeah, I'm actually getting it for every page. Here is a description of the "Done with errors on page" description of the errors. It might just be me but I...

I found out that the application is running these backups. I unchecked the jobs it called Journal Management which I believe is what is causing the Journal database to switch...

Good point. I was just on the server grabbing those .trc files and saw backups located in a strange directory or the databases...yet there are no jobs or maintenance plans...

Good point. I was just on the server grabbing those .trc files and saw backups located in a strange directory or the databases...yet there are no jobs or maintenance plans...