Creating SQL Server Group.

[Archana Kolambe]

Hi all,

I am new to sql server. On my Pc i have sql server 2000 installed and there is one sql server group present which is containing databases which all other peoples are also using.

That menas that database is located at central place from wher all we are accessing that database.

What i want is i want to create new sql server group whcih will stored databse locally to my PC.

So my question is how can i make my maching to act as a server so that it can get added to sql server list which is getting displayed in new sql server registration' dialog.

Can anyone help me.

Any help will be truely appreciated.

Thanks in advance.

[Shuja Ali]

If you do not have a Server installed on your System then you cannot register it. But you can install MSDE on your local System which is a subset of SQL Server and is free. And then have all your databases created in this SQL Server.


Also do you have SQL Server installed or just the Client tools?

[exterminator]

What i want is i want to create new sql server group whcih will stored databse locally to my PC.
The simplest way to do this is .. create a database (a new group and database with the same name as what others or the centralized one has ..) and copy the .MDF and .LDF from that server to your local machine SQL server directory (i dont remember the actual path but you can do a windows search for it).. that's the easiest way to get this done.. or else .. there is a lengthy process of getting a schema generated out of existing database and executing the sql script and the doing a back-up from server .. and then doing a restore on your machine... Let us know what you actually want to ... ;) Regards.