Viewing 15 posts - 241 through 255 (of 312 total)
I think we are a little bit stingy when it comes down to giving extra space to the log file. Lesson learned.
1 more question. When the log file gets filled,...
"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 28, 2014 at 8:48 am
See the attachment.
"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 28, 2014 at 8:24 am
JoshDBGuy (3/28/2014)
"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 28, 2014 at 8:17 am
Grant Fritchey (3/28/2014)
It's also possible that you have a...
"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 28, 2014 at 8:06 am
GilaMonster (3/28/2014)
What is the recovery model?
It was set to Full until this morning but one of our DBA put the DB to Simple recovery mode.
"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 28, 2014 at 8:02 am
Thank you Sir!;-)
"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 22, 2014 at 7:59 am
I just want to make sure that I understand you correctly.
I can have 1 instance for 2 databases and if I need to refresh it from the production "TEST" to...
"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 21, 2014 at 1:08 pm
We were just moving the databases because we had 2 databases using the same drive. We just wanted to put them on a separate drive, so if 1 runs out...
"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 15, 2014 at 6:12 pm
GilaMonster (3/15/2014)
ALTER DATABASE with the WITH MOVE clauseTake the database offline
Copy the files to their new location
Bring the DB online.
Test in a dev/test environment first.
Unfortunately, we did that in prod...
"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 15, 2014 at 9:41 am
Thanks for replying.
This is how I ended up setting the environment. Please let me know if its OK.
Since it's only 8 GB in size, I am taking full...
"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 14, 2014 at 1:16 pm
Perry Whittle (3/14/2014)
Restore the full backup, followed by the last diff then restore the logs up to the desired recovery time of 1:55
Thanks Perry
"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 14, 2014 at 10:48 am
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,...
"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:33 pm
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...
"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:41 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:06 am
Done.
Thank you so much everyone for taking some time out to help me....
"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 5, 2014 at 12:40 pm
Viewing 15 posts - 241 through 255 (of 312 total)