Viewing 15 posts - 106 through 120 (of 309 total)
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...
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...
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...
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...
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] =...
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...
March 4, 2015 at 11:41 am
Perry Whittle (3/3/2015)
any luck?
Not yet
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...
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....
March 3, 2015 at 7:33 am
New Born DBA (3/2/2015)
Perry Whittle (3/2/2015)
March 2, 2015 at 3:32 pm
Perry Whittle (3/2/2015)
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...
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.
March 2, 2015 at 9:55 am
Already created a view from tables
Create View [dbo].[HistInfo] AS
SELECT [UniqueID]
,[Company]
,[CustID]
,[CustomerName]
...
February 19, 2015 at 1:46 pm
Viewing 15 posts - 106 through 120 (of 309 total)