Viewing 15 posts - 106 through 120 (of 312 total)
Thanks Gail
"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]
April 1, 2015 at 8:48 am
I think I got it. Thanks!
"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 19, 2015 at 11:05 am
We use SolarWinds DPA tool to monitor our environment. Everyday I see alerts regarding the blocking. For example, Query 1 gets executed 3700 times and has 17 hours of blocking...
"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 19, 2015 at 10:23 am
Disabled the log shipping job and recreated it and now it's working. I have no idea why it wasn't working. Didn't take any extra steps. Recreated the same way, I...
"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 6, 2015 at 10:21 am
Perry Whittle (3/5/2015)
select differential_base_lsn, differential_base_time
from sys.master_files
where database_id = DB_ID('yourdb')
and type = 0
group by differential_base_lsn, differential_base_time
If 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 5, 2015 at 11:36 am
I don't know what I am missing, but Log shipping is working between instances in the same server, but it is not working between 2 different servers.
Little explanation of what...
"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, 2015 at 9:32 am
This is what I did.
I logged in as "SA"
Ran this command
SELECT sd.[name], sp.spid, sp.login_time, sp.loginame
FROM sysprocesses sp
INNER JOIN sysdatabases sd on sp.dbid = sd.dbid
WHERE sd.[name] =...
"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 4, 2015 at 11:59 am
Followed everything in this thread recommended by everyone, but nothing seems to be working.
Ran this command which brought 0 result
SELECT sd.[name], sp.spid, sp.login_time, sp.loginame
FROM sysprocesses sp
INNER JOIN sysdatabases...
"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 4, 2015 at 11:41 am
Perry Whittle (3/3/2015)
any luck?
Not yet
"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 3, 2015 at 1:35 pm
Perry Whittle (3/3/2015)
even though the restore job is successful, check the step outputs, you'll likely see errors there saying "log file skipped blah blah blah"
Nope. I don't see any error...
"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 3, 2015 at 8:04 am
It was just permission issues. That problem has been fixed.
New problem:
I created a dummy table in the DB (Primary Server) last night. I scheduled it to run every 15 minutes....
"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 3, 2015 at 7:33 am
New Born DBA (3/2/2015)
Perry Whittle (3/2/2015)
"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 2, 2015 at 3:32 pm
Perry Whittle (3/2/2015)
"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 2, 2015 at 10:36 am
Perry Whittle (3/2/2015)
New Born DBA (3/2/2015)
Restored with recoveryThe secondary database must be restored with either NORECOVERY or STANDBY.
1 more question I have regarding the log shipping.
This is how the primary...
"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 2, 2015 at 10:11 am
Let me try that and if I run into any issues, I will just reply to this thread 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]
March 2, 2015 at 9:55 am
Viewing 15 posts - 106 through 120 (of 312 total)