Hi,

Go out and buy the textbook. You can get hold of a secondhand copy on Amazon or similar site for a very reasonable price.

The book also comes with a CD...

Hi,

I would not recommend that you change the restore mode of your configuration as if you are using the with No Recover option the database will not even be accessible...

Hi,

The line from you error message included below would seem to suggest that the log files are being located successfully but that they are unable to applied to the database.

2008-06-13...

Hi,

SSAS is quite a big subject area. Take a look at some of the video tutorials on the following site. A wealth of information is available.

http://channel9.msdn.com/posts/ZachSkylesOwens/Business-Intelligence-09c-Using-the-Cube-Wizard/

Cheers,

John

Great comments ola!

I'm sure you already know this, but for those that may not, the reason why smaller indexes become fragmented quickly is because there are fewer index levels and...

Hi,

Rather than using a cursor, you can insert your data into an ordered table by using a identity column. Then just create a typical loop data structure to sequence through...

Hi,

I would recommend that if you are configuring your database on clean hard disks, that you reserve as much space as you think you will realistically need for the database....

Hmmm, this is a long shot but I wonder if this could be permission issue? What privileges have been granted to the account you are using to connect to...

Hi,

Have you tried browsing to the log files on the file system?

They typically live in a location similar to the following.

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

Hi,

Not wanting to sound witty, although I am a funny guy, are you sure you have not just installed the client components during the installation process?

On the "Components to Install"...

Hi,

I am a little confused as I was under the impression that all SQL Server Backups were online, so perhaps another poster can clarify this point?

My question was looking at...

Hi Sony,

RAID is a technology that is available for use with a disk array yes.

Quite a big subject area to get stuck into however the following link may prove benificial...

Hi,

Also, keep in mind that if you are using a single disk, you will see little if any performance gain by using multiple file groups.

The purpose of Filegroups is primarily...

Hi,

What type of backup are you performing in the morning?

The error would appear to suggest that the sequence of log files is being interrupted. This will occur if you perform...

Hi,

select @@servername

Will return the name of the current server.

Cheers,

John