Using MS SQL 2000 .bak file with SQL2005

[bjose]

Hi,

I have a bak file of MS SQL server 2000 and now I want to use this with MS SQL 2005.

Anyone please advice
Thanks
Jose

[Purple]

Hi bjose,

Welcome to TSDN MSSQL forum.

If you are trying to restore a database from a backup to allow for testing and development on SQL 2005, I have found taking a copy of the database and log files a much better way to achieve this..

Take a read of this for some specifics on one approach..

Regards Purple

[bjose]

Thanks a lot. It worked. You are great.

I have one more question, is, I want to remove my login credentials from SQL server login window. It always rembember the server names I connected, and my login name. I want to avoid the same.

Thanks
Jose

Hi bjose,

Welcome to TSDN MSSQL forum.

If you are trying to restore a database from a backup to allow for testing and development on SQL 2005, I have found taking a copy of the database and log files a much better way to achieve this..

Take a read of this for some specifics on one approach..

Regards Purple

[Purple]

Hi,

Am pleased it did the trick for you..

Your username / password are being stored by windows cause you ticked the remember these details checkbox I think.. Clearing stored passwords is done in different places depending on the operating system..

What version of windows are you running ?

Regards Purple

[bjose]

I am using Vista Business and XP Pro

Waiting for your reply

Thanks
Jose

Hi,

Am pleased it did the trick for you..

Your username / password are being stored by windows cause you ticked the remember these details checkbox I think.. Clearing stored passwords is done in different places depending on the operating system..

What version of windows are you running ?

Regards Purple

[Purple]

Hi,

is this in sql server management studio ?

Purple

[bjose]

Yes. Developer edition

Thanks
Jose

Hi,

is this in sql server management studio ?

Purple