here is where I am now I have change everything to T-sql

BACKUP DATABASE test TO DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\test9.bak' WITH NOINIT, SKIP

RESTORE FILELISTONLY FROM DISK = 'D:\Program Files\Microsoft...

ok I was backinp using the GUI, so now I use your statment and here is my error.

ran this...

BACKUP DATABASE test TO DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\test9.bak' WITH NOINIT,...

Mark did you try that in 2000 or 2005. I am still not able to make it work using 2005

thanks

let me correct my self

I seleced device.

Then the button that took me to file.

Browse and selected the .bak file.

seems like it should work..

hi guys,

I thought the same thing and tried it... I did from device and then selected a .bak file. and then hit restore. It give me the errror

"must select source"...

Thanks that worked!!!

here is good place to start, there is segment for Ram that will get u moving in the right direction.

GOOD LUCK!!

http://www.sql-server-performance.com/sql_server_performance_audit3.asp

try yo keep your ram = to your db size. this will keep i/o paging to a min.

if this is not possible then run your performance monitor: Buffer Cache Hit...

I agree with allen, do a restore from your upgraded db to the backup.This will accomplish two thing. One its a good time to test your restore. Two you will...

Worked great THANKS!!!!!

Thanks Guys tried all of the above, WORK like CHARM!!!!!!!

It worked, that was way to easy!!

Sometime one can not see the forest from the trees.

THANKS AGAIN.

NICE,NICE,NICE

THANKS SO MUCH

irrelevant as may be THANKS you very much!!