Thanks Sue. It all makes sense now. Appreciate your help.

Try using this... It is free and customizable. You can simply setup a job with this command and run.

https://docs.dbatools.io/#Copy-DbaDatabase

Although I am still unclear on why this would happen, that fixed the issue.

Thank You Sue

If you must know my secret.... I am trying a smoke test, if we receive an alert from our Customized system in case log gets full for any database. Part...

Thanks a ton for your help :). This means if I have a cluster with 8 Core CPU on both nodes, 1 will have to pay for 16 cores in...

Thanks for your response. 🙂

Another quick one. When I run these instances on a cluster, does it makes a difference in licensing cost if half of the instance run on...

Thanks for your reply Gary

I am not trying to use different technologies. Only one of these is sufficient. Just want to know which one.

can u elaborate a bit on runas...

But if I restore from another server where there is no replication setup on the DB, would the Publisher still work after restore ?

Yes... the Current DB is going to be restored from a backup of Production server every 10 days.

Thanks man... u rock.

Koen Verbeeck (11/7/2011)

By changing the property...

Thanks.... Got it.

Could you please tell me how can we change this default measure, if we have to !!!

SELECT

{[Date].[Calendar].[Calendar Quarter].&[2007]&[1],

[Date].[Calendar].[Calendar Quarter].&[2007]&[2] } ON AXIS (0),

[Reseller].[Reseller Type].[All Resellers] ON AXIS (1)

FROM [Adventure Works]

where [Measures].[Reseller Sales Amount]

and

SELECT

{[Date].[Calendar].[Calendar Quarter].&[2007]&[1],

[Date].[Calendar].[Calendar Quarter].&[2007]&[2] } ON AXIS (0),

[Reseller].[Reseller Type].[All Resellers] ON AXIS (1)

FROM [Adventure Works]

give...

This may be a simple thing but... How can I find out which row was deleted ?

Thanks

Hi,

Its a great step by step tutorial.

I have setup as instructed (well almost) but when I go to SQLNode2-> iSCSI Initiator -> Target Tab, it shows all the targets but...

Thanks for the reply.

I have the understanding about the logical files. I just wanted to find out if there is a way to increase them or not. or may be...