Yes, I did - and you knew exactly what you were looking at, but the other guy said it "looked like" something, so I gave him a resource that would...

First of all, what OS are you running and is this a 32 bit or 64 bit server?

This really has a lot to say for how memory is handled....

Yes, my apologies for not being more precise. When there are more than 8 CPU cores, I generally don't create a TempDB file for each one above the initial 8....

The "GO" is not needed in this context, it's basically used to separate different batches of code. It's an old thing we inherited from the days of Sybase T-SQL on...

For best results, if you're running a busy production server, you should place TempDB on a seperate drive and split it up into one file for each CPU. That way,...

Here's a great overview of versions and builds: http://www.sqlsecurity.com/faqs-1/sql-server-versions

The version number in the file properties (and in server properties inside Management Studio) lets you know exactly what build you're...

Good, you've found your backups then. Hopefully you should find the ones you...

Actually, there should be a log from the previous run, but I'm unsure where that would be on your system.

Anyone else have some input here?

It's not necessarily a problem, just something you'll need to be aware of.

Each new version...

ambesh.bharadwaj (10/16/2012)

---

only problem will occur when you are testing failover since all of the new features of 2008 instance will not be available and you may face issue with jobs...

Interesting! This also shows just the one instance. Does SQL Server Configuration Manager also show just one?

As Gail says, your installed programs overview shows 2 installations - one 2005 and...

I'm not sure what caused your data file to grow and why you were unable to shrink it more than 2 gb, I wouldn't worry about it unless I really...

For the record, I might add that a truncate log does not actually clear individual records or transactions from the log. It simply clears all VLFs (Virtual Log Files) that...

First of all, a transaction has to be committed in order for any updates it has made to become "official" in the database. In other words, you don't actually change...

Hello.

Yes, you will need to restore transaction log backups (or a diff) if you are restoring to a point in time which is more recent than your latest full backup....