469,578 Members | 1,742 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,578 developers. It's quick & easy.

Database Restore Checklist and sql2005 running on virtual machines

Hi guys,

I want to know if there is any checklist available that one can follow before moving the databases from one server to another one.

I am a newbie in SQL stuff and facing the following problems:

I have SQL2005 running on a virtual machine, and have restored some databases which I moved from SQL2000. As a standard issue, I can't access my databases using my conventiional user logins. Have tried a lot of things as available on the internet, but nothing worked. I am still unable to connect to my database.

I need to know, first, how to check if I have the right permissions and roles set in my SQL 2005 after restoring the DBs. 2nd how can I test if my logins are working fine in the absence of any other microsoft application on my virtual machine. I have Windows Server 2003 environment in the virtual.

Sep 11 '07 #1
0 984

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Jon Jacobs | last post: by
2 posts views Thread by Massimiliano Campagnoli | last post: by
5 posts views Thread by chow.justy | last post: by
9 posts views Thread by Nemisis | last post: by
2 posts views Thread by Alex | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.