how to create filegroups

I was directed to create filegroups so that clients that install msde or sql
server would look the same Can anyone point me in the right direction on how
to
create the filegroups on msde.
I was thinking about just splitting up the indexes and tables at this
point. Is this what a sql server install would do so that they could take
advantage of Raid drive?
See Filegroups|Creating in Books Online. The basic syntax is:
ALTER DATABASE <dbname> ADD FILEGROUP <filegroupname>
Then add files to the filegroup with:
ALTER DATABASE <dbname> ADD FILE (NAME = <filename>) TO FILEGROUP
<filegroupname>
Jacco Schalkwijk
SQL Server MVP
"Keeper" <Keeper@.discussions.microsoft.com> wrote in message
news:A271C5F7-636B-4E88-B2EE-D9DFED0FB3DF@.microsoft.com...
>I was directed to create filegroups so that clients that install msde or
>sql
> server would look the same Can anyone point me in the right direction on
> how
> to
> create the filegroups on msde.
> I was thinking about just splitting up the indexes and tables at this
> point. Is this what a sql server install would do so that they could take
> advantage of Raid drive?
>
|||i appreciate the information
thanx
"Jacco Schalkwijk" wrote:

> See Filegroups|Creating in Books Online. The basic syntax is:
> ALTER DATABASE <dbname> ADD FILEGROUP <filegroupname>
> Then add files to the filegroup with:
> ALTER DATABASE <dbname> ADD FILE (NAME = <filename>) TO FILEGROUP
> <filegroupname>
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Keeper" <Keeper@.discussions.microsoft.com> wrote in message
> news:A271C5F7-636B-4E88-B2EE-D9DFED0FB3DF@.microsoft.com...
>
>

How to create Database and tables in MSDE

I have install the MSDE from Ofiice 2000 cd and my MSDE sql server is running fine that I can see from my tray bar with green arrow button. Now i want to create the database so can any body tell me how do i create database. Is there ne query analyser or enterprise manager by which I can create database. Also when i try to install starterkit it doen not allow me to install it. It ask me to select database from the dropdown list and when I select Localhost (only option available) and click on test connection it gives me error Unsuccessfull

I am new at MSDN so please help me.

Yoiu have a couple of options.
1) You can rul SQL scripts directly against MSDE using the command line interface that comes with it.
2) If you have Access 2000, XP, or 2003, youcan create a new "Access Project" and connect to your MSDE instancegraphically.
3) For ~$50 U.S, you can purchase a copy ofSQL Server 2000 Developer Edition, and connect to MSDE via EnterpriseManager.
4) You can download and install a copy of SQLServer 2000 Evaluation Edition, and use Enterprise Manager fromthat. Attempt to decipher its licensing limitations at your ownrisk.
|||Could u tell me where to find command line b'se i tried to find it but coudn't. Sorry i m new at MSDE. pls tell me how can I connect through access project. Also I am unable to install Starter kit too.
Pls help me|||The command line tool is called osql.exe. Here's an article that'll help you use it: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003
For connecting though an Access Project, either follow the wizard, or look it up in Access help.

|||Thank you very much for your answer. I was able to find out the osql.exe utility.
I am having one problem when I try to execute the command osql -e it ask me password and when i type 'sa' as password it gives me error that the username is not associated with trusted sql server. I think when I installed the MSDE I did not give it any strong user name and password so I wil try again by giving strong [password t the time of installing it.
Once again thanx very much for your time.sql

How to Create a setup file to install Sql Server Database

Hi All,
I'am looking for a software (Installer) to create a setup file to install a SQL Server Database just like the one in theReports Starter Kit, when you install it a dialog will guide you to instaal the database thats what i'am looking for.
Anybody knows how can i do that or is there a software that can help me doing that.
Best Regards.
Wafi MohtasebIf you find it let me know.|||

I am not sure if it is possible because Microsoft tried it with AdventureWorks 2000 using InstallShield but it did not work. Now to what works the old AdventureWorks 2000 is an MSI file that creates an application with Instawdb.sql file inside the application open it with note pad and execute in Query Analyzer and you have the database. So you need Windows Installer redistributable and a detailed read me. Hope this helps.

How to create a new named instance

Hi,

I did install SQL-server developer edition. During the installation it asked me the name of de instance. I let the installation create the default Named instance.

Now I want to add an instance with a new name. What is the best way to do this? Is this the same as creating a Notification service?

Doeb

Simply run setup again, this time choosing a named instance instead of the default. Each instance will operate independently of the other.|||

Thank you, I'll be able to create a new instance during new setup.

Is there no other way? e.g. with Notification Service?

Because when distributing my app I would prefer to have a new created named instance with our company name.

|||

No other way than that...but when you distribute your app, depending on what you're using for SQL Server editions, you can perform unattended installations that name your instance the way you like automatically. Guess I'd need more info on what you're doing here to give you any further assistance...

Notification services is not for performing installations of the database engine, it's a seperate component of SQL Server that is used for messaging, etc.

|||Thankx.

how to create a mdf db with sql server 2005 ctp?

hi,

i have installed the sql server 2005 ctp cause i couldn't install the sql server 2005 express on my computer. when i now create a database under the sql server 2005 management studio and connect from vs 2005 beta1 everything works fine for me.

but i want to create and work with the single mdf files wich are created by sql server express edition via ADD NEW ITEM -> DATABASE -> DB.MDF .

is it possible to create such a db file for xcopy deploayment use?

thanks
Yavuz BogazciYavuz,

The functionality you speak of is only available with SQL Server Express. What problems did you encounter while installing Express?

Dan

How to cosolidate databases of SQL Express from multiple installations?

1. install a SQL Express instance such as myexpress;

2. create some databases with tables such as db1 and db2;

3. Reinstall SQL Express with the same instance name "myexpress". I assume we need reinstall SQL Express myexpress again becuase of bad operations.

4. Open the myexpress by management tool but I can not see db1 and db2 databases but the datafiles and logfiles are in the data directory.

The question is what I need to do so I can consolidate exited databases so they can be seen in "myexpress" instance by management tool?

hi,

WhyHere wrote:

1. install a SQL Express instance such as myexpress;

2. create some databases with tables such as db1 and db2;

3. Reinstall SQL Express with the same instance name "myexpress". I assume we need reinstall SQL Express myexpress again becuase of bad operations.

4. Open the myexpress by management tool but I can not see db1 and db2 databases but the datafiles and logfiles are in the data directory.

The question is what I need to do so I can consolidate exited databases so they can be seen in "myexpress" instance by management tool?

reinstalling the database engine will actually overwrite your used master database... the master database contains the "registration" of each user database so that the "clean" master does not include those registrations... you can re-attach your existing database files via the

CREATE DATABASE xxx

ON (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\xxx.mdf'

)

FOR ATTACH ;

statement... please have a look at http://msdn2.microsoft.com/en-us/library/ms176061.aspx for further info about it's synopsis... this will result re-registering a database from it's physical files...

BTW, overwriting the master database will also clean-up all logins information about all SQL Server and Windows NT principals.. associated (for SQL Server standard logins only) database users must also be cleaned/syncronized, for each user, via the sp_change_users_login system stored procedure, as reported in http://msdn2.microsoft.com/en-us/library/ms174378.aspx..

regards

How to copy user in master database to new server?

I just install new server for testing only. I have problem about user in
master database. How to copy all user from production server to testing
server?Are you referring to users in the master database or logins? Also, what version of SQL Server?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:A01991A7-16F8-4E16-BC3F-EA21842E8011@.microsoft.com...
>I just install new server for testing only. I have problem about user in
> master database. How to copy all user from production server to testing
> server?|||Hi
I assume you are meaning logins rather than users which can be scripted. To
transfer logins check out http://support.microsoft.com/kb/246133/
John
"Mesak" wrote:
> I just install new server for testing only. I have problem about user in
> master database. How to copy all user from production server to testing
> server?|||If I have backup site (another building). I test system at backup site one
time per year. Do you have any solution to copy login to new server at backup
site?
Thank you.
"John Bell" wrote:
> Hi
> I assume you are meaning logins rather than users which can be scripted. To
> transfer logins check out http://support.microsoft.com/kb/246133/
> John
> "Mesak" wrote:
> > I just install new server for testing only. I have problem about user in
> > master database. How to copy all user from production server to testing
> > server?|||Hi,
Use the below URL:
http://www.databasejournal.com/features/mssql/article.php/2228611
Thanks
Hari
SQL Server MVP
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:B4198F70-AAEC-4B94-921E-602D2ACF2D9C@.microsoft.com...
> If I have backup site (another building). I test system at backup site one
> time per year. Do you have any solution to copy login to new server at
> backup
> site?
> Thank you.
> "John Bell" wrote:
>> Hi
>> I assume you are meaning logins rather than users which can be scripted.
>> To
>> transfer logins check out http://support.microsoft.com/kb/246133/
>> John
>> "Mesak" wrote:
>> > I just install new server for testing only. I have problem about user
>> > in
>> > master database. How to copy all user from production server to testing
>> > server?|||The solution to copy login is in the URL that John posted:
http://support.microsoft.com/kb/246133
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:B4198F70-AAEC-4B94-921E-602D2ACF2D9C@.microsoft.com...
> If I have backup site (another building). I test system at backup site one
> time per year. Do you have any solution to copy login to new server at backup
> site?
> Thank you.
> "John Bell" wrote:
>> Hi
>> I assume you are meaning logins rather than users which can be scripted. To
>> transfer logins check out http://support.microsoft.com/kb/246133/
>> John
>> "Mesak" wrote:
>> > I just install new server for testing only. I have problem about user in
>> > master database. How to copy all user from production server to testing
>> > server?

How to copy user in master database to new server?

I just install new server for testing only. I have problem about user in
master database. How to copy all user from production server to testing
server?
Are you referring to users in the master database or logins? Also, what version of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:A01991A7-16F8-4E16-BC3F-EA21842E8011@.microsoft.com...
>I just install new server for testing only. I have problem about user in
> master database. How to copy all user from production server to testing
> server?
|||Hi
I assume you are meaning logins rather than users which can be scripted. To
transfer logins check out http://support.microsoft.com/kb/246133/
John
"Mesak" wrote:

> I just install new server for testing only. I have problem about user in
> master database. How to copy all user from production server to testing
> server?
|||If I have backup site (another building). I test system at backup site one
time per year. Do you have any solution to copy login to new server at backup
site?
Thank you.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I assume you are meaning logins rather than users which can be scripted. To
> transfer logins check out http://support.microsoft.com/kb/246133/
> John
> "Mesak" wrote:
|||Hi,
Use the below URL:
http://www.databasejournal.com/featu...le.php/2228611
Thanks
Hari
SQL Server MVP
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:B4198F70-AAEC-4B94-921E-602D2ACF2D9C@.microsoft.com...[vbcol=seagreen]
> If I have backup site (another building). I test system at backup site one
> time per year. Do you have any solution to copy login to new server at
> backup
> site?
> Thank you.
> "John Bell" wrote:
|||The solution to copy login is in the URL that John posted:
http://support.microsoft.com/kb/246133
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:B4198F70-AAEC-4B94-921E-602D2ACF2D9C@.microsoft.com...[vbcol=seagreen]
> If I have backup site (another building). I test system at backup site one
> time per year. Do you have any solution to copy login to new server at backup
> site?
> Thank you.
> "John Bell" wrote:

How to copy user in master database to new server?

I just install new server for testing only. I have problem about user in
master database. How to copy all user from production server to testing
server?Are you referring to users in the master database or logins? Also, what vers
ion of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:A01991A7-16F8-4E16-BC3F-EA21842E8011@.microsoft.com...
>I just install new server for testing only. I have problem about user in
> master database. How to copy all user from production server to testing
> server?|||Hi
I assume you are meaning logins rather than users which can be scripted. To
transfer logins check out http://support.microsoft.com/kb/246133/
John
"Mesak" wrote:

> I just install new server for testing only. I have problem about user in
> master database. How to copy all user from production server to testing
> server?|||If I have backup site (another building). I test system at backup site one
time per year. Do you have any solution to copy login to new server at backu
p
site?
Thank you.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I assume you are meaning logins rather than users which can be scripted. T
o
> transfer logins check out http://support.microsoft.com/kb/246133/
> John
> "Mesak" wrote:
>|||Hi,
Use the below URL:
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
SQL Server MVP
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:B4198F70-AAEC-4B94-921E-602D2ACF2D9C@.microsoft.com...[vbcol=seagreen]
> If I have backup site (another building). I test system at backup site one
> time per year. Do you have any solution to copy login to new server at
> backup
> site?
> Thank you.
> "John Bell" wrote:
>|||The solution to copy login is in the URL that John posted:
http://support.microsoft.com/kb/246133
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:B4198F70-AAEC-4B94-921E-602D2ACF2D9C@.microsoft.com...[vbcol=seagreen]
> If I have backup site (another building). I test system at backup site one
> time per year. Do you have any solution to copy login to new server at bac
kup
> site?
> Thank you.
> "John Bell" wrote:
>