Viewing 15 posts - 5,761 through 5,775 (of 6,400 total)
Gianluca Sartori (2/29/2012)
GilaMonster (2/29/2012)
Gianluca Sartori (2/29/2012)
GilaMonster (2/29/2012)
Gianluca Sartori (2/29/2012)
SQL Server 2012 will be out in some days.
The marketing launch event is in a couple of days. Availability of the bits,...
February 29, 2012 at 4:37 am
I dont think you will personally have a problem with this as long as you are moving to the same version.
The only thing I would say is that with backing...
February 29, 2012 at 4:35 am
Depends what you want to use it for.
Please detail what you are trying to acheive.
February 29, 2012 at 4:30 am
Sorry guys, it was a bit much, there where a few posts the day I changed to that avatar which made me upload it as I did feel like banging...
February 29, 2012 at 1:50 am
2012 is still in the release candidate stages, no RTM has yet to be released.
The latest official version is 2008 R2, if you can wait till July then 2012 should...
February 29, 2012 at 1:49 am
what is the serverity and state of the 18456 error, that will then all depend on the action/s to take
February 29, 2012 at 1:36 am
if it gives you the information you need then its fine
February 28, 2012 at 8:27 am
yeah that will work, but in the case you will want it to be IS NOT NULL as I have just run this on my test machine with NO logshipping...
February 28, 2012 at 8:04 am
you will want something like this
select
LP.Primary_Database as LogshippingDB,
'' AS NotLogshippingDB
from
msdb..log_shipping_monitor_primary lp
union
select
'',
sd.Name
FROM
sys.databases SD
LEFT OUTER JOIN
msdb.dbo.log_shipping_monitor_primary lp
ON
sd.name = lp.primary_database
WHERE
lp.primary_database is null
February 28, 2012 at 7:13 am
your syntax is wrong for the whole query
you need the 3 part identifyer
msdb.dbo.log_shipping_monitor_primary
when you correct it you will get
Msg 4104, Level 16, State 1, Line 7
The multi-part identifier "dbid.SD"...
February 28, 2012 at 7:03 am
put your CV up on the job boards like totaljobs.com/jobsite.co.uk/monster.co.uk/contractjobs.com, you will get plenty of agencies contacting you.
i've just started a new role and i'm still constantly being called by...
February 28, 2012 at 5:25 am
as the primary table contains DB's which are logshipping configured you wuold just tie it back to sys databases where its not in the primary table
February 28, 2012 at 4:50 am
the script zip attachment has been removed by the OP, i managed to get a copy of it before it was removed
February 28, 2012 at 3:21 am
this url will help http://msdn.microsoft.com/en-us/library/ms175106.aspx
the table your looking for is log_shipping_monitor_primary which details all the source db's which are involved in logshipping
February 28, 2012 at 3:19 am
the information on that is in the wiki link.
port 445 is the port used for file copy's so that both nodes can copy TRN files
February 28, 2012 at 2:28 am
Viewing 15 posts - 5,761 through 5,775 (of 6,400 total)