Not sure whether this will be useful or not.

We run our maintenance jobs for indexes at a table level. So the following command will

work for any index associated with...

Can you explan further what you plan to do by "lock pages in memory".

What is the significance of adding an account and restarting sql server service

Here is the reply to your questions

1.) Our Server is a 64 bit OS

2.) This is what I get when I run the Select @@version command

Microsoft SQL Server 2005 -...

Not sure what you mean by the following:

If it's a 32 bit OS or SQL Version, enable AWE then /PAE in the boot.ini file

We just upgraded to 32 GB ( The max for the server ).

I beleive the operating system needs about 2 GB or RAM.

So how much would you recommend ( the...

Hi Lynn

Thanks for giving me the syntax for the restore command.

I just ran it went for 45 minutes with no errors.

Went fine!

Now my next step is to do a backup...

OK everything went smooth

Can somebody tell me the syntax for creating a full backup on a database.

First do i have to create a backup set

Ok I guess I am ready to call it a day!

As we speak they are copying the full backup to a special drive that can be connected to the new...

Sorry for the confusion.

You were right!

That was a transaction log.

We did find the actual backup file it is 78GB large and also there was a second file

that was 12GB large.

I...

I believe there was a syntax error

restore headeronly N'D:\NGProd_backup_201001280600.trn'

restore filelistonly N'D:\NGProd_backup_201001280600.trn'

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'D:\NGProd_backup_201001280600.trn'.

--The file name is spelleed correctly

True, I agree.

Our DB Admins are using the ".trn" extension for a full backup.

Please see the attached image that I sent earlier. You will get an idea whether we are...

Please see attached image.

This will give you some idea of whether we have a full backup or not.

Please reply. Your help is appreciated

Thanks

That is close. I ran into an error.

Right now, the new server does nto have any database by the name "NGPROD" created.

Do I have to first create a database by...

The following is the script obtained from SQl sever 2005.

This will tell you where each file is.

question: The new sever only has 2 drives. I really don't care if all...

Not sure what you mean.

The new server is brand new.

There is just 2 drives ( C and D )

D where SQl sever software sits.

So then, I am free to create...