Viewing 15 posts - 1 through 15 (of 85 total)
If you are upgrading SQL 2012 to 2016 then you will need to upgrade the packages also or they will fail when run against a 2016 instance. If I were...
July 11, 2018 at 10:56 pm
Literally all I have is a SQL Error Log full of:
Database 'DBname' cannot be opened. It is in the middle of a restore.
Error: 927, Severity: 14, State: 2.
I see nothing...
February 14, 2013 at 4:31 pm
You're absolutely right; it doesn't. However I did, and still believe its necessary, and ran them again on failback and have no problems so, rightly or wrongly, it doesn't...
February 14, 2013 at 4:07 pm
Just thought I'd add that I failed back this morning using exactly the same process and I'm not now seeing these errors occur on the secondary. Suspect that the...
February 14, 2013 at 3:38 pm
Sorry I gave general process when I should have been specific. All steps in that article are covered. Databases all appear in the correct log shipping system tables and don't...
February 14, 2013 at 5:14 am
Its interesting that you say:
chinn_chris (10/23/2012)
What frustrates me is that the DBA is often resentful of helping the developer in getting the issue resolved.
I certainly have felt that same sentiment,...
October 23, 2012 at 6:49 pm
dan-572483 (10/12/2012)
Lesson learned: If you are doing massive changes to a large database that you'll want to reverse, use a full backup, not a snapshot.http://support.microsoft.com/kb/2002606
Dan
The article is very...
October 16, 2012 at 12:07 am
Jeff Moden (9/3/2012)
Also, have you considered doing any kind of background investigation, drug testing, etc?
Yikes! Pleased to be on a different continent:alien:
September 21, 2012 at 12:49 am
Danzz (9/18/2012)
1)Job on DBSTU server: Agent history clean up: distribution is failing.
From the Job error I figured out was Table [dbo].[MSmerge_history] on distribution was missing.
This is causing issue?...
September 18, 2012 at 10:40 pm
A red cross against a Publisher is an indication that there is a problem with the replication. If you drill down into it, what do you see?
September 18, 2012 at 9:01 pm
ok stop posting random questions. No one is going to help you when you're posting in this way.
You began posting about being unable to create a...
September 18, 2012 at 7:50 pm
You are posting new threads all over the place regarding, essentially, the same issue. I have already responded on two, but you are throwing bits of information in all...
September 18, 2012 at 7:27 pm
Danzz (9/18/2012)
sp_get_distributor:
installed...
September 18, 2012 at 7:21 pm
If you execute sp_helpdistpublisher at the distributor, it should return a list of any publishers currently configured to use the distributor.
Then you can force dropping of the publisher...
September 17, 2012 at 7:50 pm
There's no reason why you can't just go ahead and install the 32-bit version. As far as I know there is no 64-bit version of SSMS for SQL 2005.
September 17, 2012 at 6:08 pm
Viewing 15 posts - 1 through 15 (of 85 total)