Database File

Hello, I have a database with a very big datafile (6 gb), and I would Like to add more datafiles and why not 1 more db group... How do I distribute the data to the new datafiles ?

I'm doing this cause I'm having some serious performance problems...

Should I create those datafiles on separate disks or in the same one ?

Thank you so much for your help...

refer these

http://www.mssqlcity.com/FAQ/Devel/move_tables.htm

http://www.mssqltips.com/tip.asp?tip=1112

Madhu

|||

Hi Julian,

I am afraid, there is no simple answer to this question.

It all depends on how your storage is configured.

There is one important point, if you have two different datafiles sitting on two different logical drives at the windows level, SQL Server will use two threads to perform the IO. So you might see a bit of a performance benefit in that.

E.g. You have two drives E and F and your current file is on drive E. I would add another data file on the F Drive in the same filegroup.

regards

Jag

Database distribution

Hi,
I am going to distribute a webb site and need to distribute the databases used by this webbsite. A newbie as I am to databases I ask if there is any tool to extract the databases from my machine, store it on a CD and then install it on another machine.
Thing is... I want to distribute the databases, but not the data currently stored in it.

Gudday!1. No such a tool as I know.
2. Backup your database and restore it with different name.
3. DROP TABLEs unusable to user (all user tables), analytic tables ...
4. In this database, use DELETE/TRUNCATE TABLE statements (See BOL) to clear your tables. If you use some tables for configuration, you cannot delete them !!!
5. Select distribution type BACKUP/Script. Script (made for example by EM) is most version compatible, but it takes some time to create it, if you distibute also data.
6. BACKUP installation files for testing UPGRADE.
7. Installation of database on user side can be done by runing script by isql.exe by installation program ( most use InstallShield )
8. Installation is a nightmare of each advanced developer:mad:|||Is it possible to use method of detaching the database, copy the files, distribute files and finally attach the database on remote site?

// Dobaz|||I have a similar situation in my company.I had gone for creating the scripts of the database ,since i also needed the data in the database, the size of the database file was too big .
if u script the database u have total control over it .|||You can use a outer program to restore the database during the installitaion or the program's first running.|||Thanks for all replies and help!

I have tried to:

1. Detached the databases that needs to be distributed from the SQL Server on my original machine.

2. Copied the .mdf and .ldf files from the MSSQL data folder onto a second machine.

3. Attached the distributed databases to SQL Server on the second machine.

It all seems to work ok between my own machines... Maybe this is a good way to go?

As I mentioned eariler I want to distribute the databases to keep table structure intact and only some example data stored in it (i.e. database files will be pretty small).