March 11, 2014 at 10:36 am
Please let me know if it doesn't make sense?
Scenario: We have 2 clients sharing a device for storage. Recovery model is set to Simple so we can't take Xlog backups, and yes this is Production environment. Since client 1 is heavily updated, it made the drive reach to 100% full which affected the other client as well. we did end up increasing the size of the drive but I was thinking that we keep different customers on separate partitions, so if one customer’s db grows unexpectedly, it doesn’t hose all the other customers. I just need to know the best way to move .mdf and .ldf files?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 11, 2014 at 10:44 am
If one of your clients will allow you to have a downtime, you can move their MDF and LDF files to a different drive by following the instructions in the Books Online article "ALTER DATABASE File and Filegroup Options (Transact-SQL)"
March 11, 2014 at 10:46 am
The attach/detach method is not recommended. Read this http://msdn.microsoft.com/en-us/library/ms345483.aspx
Igor Micev,My blog: www.igormicev.com
March 11, 2014 at 11:06 am
Thanks for the reply but I am not moving DB to another instance.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 11, 2014 at 11:37 am
New Born DBA (3/11/2014)
...Scenario: We have 2 clients sharing a device for storage....
What do you mean with the above quoted phrase:
1. two instances (with each one database) on the same server and the database files of both instances on the same drive
2. one instance with two different databases on one server and the database files on the same drive
3. one instance with one database on one server; the database holds data from 2 different clients
March 11, 2014 at 11:41 am
HanShi (3/11/2014)
New Born DBA (3/11/2014)
...Scenario: We have 2 clients sharing a device for storage....What do you mean with the above quoted phrase:
1. two instances (with each one database) on the same server and the database files of both instances on the same drive
2. one instance with two different databases on one server and the database files on the same drive
3. one instance with one database on one server; the database holds data from 2 different clients
Number 3. one instance with one database on one server; the database holds data from 2 different clients.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 11, 2014 at 12:29 pm
New Born DBA (3/11/2014)
Number 3. one instance with one database on one server; the database holds data from 2 different clients.
Do the tables hold data for a single client, or is the data from multiple clients in the same table(s)?
When a table only holds data from one single client, you could create additional filegroups. The file(s) of this new filegroup can be placed on another drive. Next you can move the tables of one of the clients to that filegroup, thus seperating clients to another disk.
If data of multiple clients is in the same table(s), there is nothing you can do (without a complete re-design).
March 11, 2014 at 12:33 pm
HanShi (3/11/2014)
New Born DBA (3/11/2014)
Number 3. one instance with one database on one server; the database holds data from 2 different clients.Do the tables hold data for a single client, or is the data from multiple clients in the same table(s)?
When a table only holds data from one single client, you could create additional filegroups. The file(s) of this new filegroup can be placed on another drive. Next you can move the tables of one of the clients to that filegroup, thus seperating clients to another disk.
If data of multiple clients is in the same table(s), there is nothing you can do (without a complete re-design).
Thanks for replying, I think you directed me to the right direction, I think I will be able to handle myself.
Thanks again!
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply