Re: MSSQL 2012 SQL permissions

[Stefan Folkerts]

Thanks all!

On Tuesday, 14 June 2016, Del Hoobler  wrote:

> Also, keep in mind, the SYSADMIN role is a Microsoft requirement:
>
> https://support.microsoft.com/en-us/kb/2926557
>
>
> Del
>
> 
>
>
> "ADSM: Dist Stor Manager" > wrote on
> 06/14/2016
> 12:47:50 PM:
>
> > From: Stefan Folkerts >
> > To: ADSM-L@VM.MARIST.EDU 
> > Date: 06/14/2016 12:48 PM
> > Subject: Re: MSSQL 2012 SQL permissions
> > Sent by: "ADSM: Dist Stor Manager" >
> >
> > version 7.1.4 of de SQL TDP, legacy backups. The customer doesn't want
> the
> > MSSQL sysadmin role for backup purposes.
> >
> >
> > On Tue, Jun 14, 2016 at 2:12 PM, Rick Adamson
> >
> > wrote:
> >
> > > Stefan,
> > > Can you provide more information, like
> > >  -what version of SQLDP are you using
> > > -are you using the legacy data protection or Flash Copy Manager (FCM)
> > > -VSS or legacy backups
> > >
> > > On older versions I ran my scheduler with an administrator account and
> > > also had TSM admins added to sysadmin role in SQL in order to be able
> to
> > > troubleshoot backup issues as well as perform restores.
> > >
> > > On the releases the TSM admins still are added to the sysadmin role to
> > > provide support but I no longer install a scheduler service and use
> the
> > > scheduler internal to DP/FCM and don't use any elevated account.
> > >
> > >
> > > -Rick Adamson
> > >
> > >
> > > -Original Message-
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU
> ] On Behalf
> Of
> > > Stefan Folkerts
> > > Sent: Tuesday, June 14, 2016 5:33 AM
> > > To: ADSM-L@VM.MARIST.EDU 
> > > Subject: [ADSM-L] MSSQL 2012 SQL permissions
> > >
> > > Hi all,
> > >
> > > Can somebody help me with the MSSQL 2012 SQL permissions that are
> needed
> > > for the scheduler user?
> > >
> > > I can find:
> > >
> > >
> > > https://urldefense.proofpoint.com/v2/url?
> >
>
> u=http-3A__www-2D01.ibm.com_support_docview.wss-3Fuid-3Dswg21368503=CwIBaQ=AzgFQeXLLKhxSQaoFCm29A=eqh5PzQPIsPArLoI_uV1mKvhIpcNP1MsClDPSJjFfxw=UtpsaRjR1lo3cxWy8yN9atqFIsgPAifd7bsFQPM5HHc=7QYYsEEwqwIBQyXRYO8Ulr-65aYw-
> > NXOSOFPrINsjWs=
> > >
> > > But that's for 2005 and it doesn't list the MSSQL permissions.
> > >
> > > Regards,
> > >Stefan
> > >
> >
>

Re: MSSQL 2012 SQL permissions

[Del Hoobler]

Also, keep in mind, the SYSADMIN role is a Microsoft requirement:

https://support.microsoft.com/en-us/kb/2926557


Del




"ADSM: Dist Stor Manager"  wrote on 06/14/2016 
12:47:50 PM:

> From: Stefan Folkerts 
> To: ADSM-L@VM.MARIST.EDU
> Date: 06/14/2016 12:48 PM
> Subject: Re: MSSQL 2012 SQL permissions
> Sent by: "ADSM: Dist Stor Manager" 
> 
> version 7.1.4 of de SQL TDP, legacy backups. The customer doesn't want 
the
> MSSQL sysadmin role for backup purposes.
> 
> 
> On Tue, Jun 14, 2016 at 2:12 PM, Rick Adamson 

> wrote:
> 
> > Stefan,
> > Can you provide more information, like
> >  -what version of SQLDP are you using
> > -are you using the legacy data protection or Flash Copy Manager (FCM)
> > -VSS or legacy backups
> >
> > On older versions I ran my scheduler with an administrator account and
> > also had TSM admins added to sysadmin role in SQL in order to be able 
to
> > troubleshoot backup issues as well as perform restores.
> >
> > On the releases the TSM admins still are added to the sysadmin role to
> > provide support but I no longer install a scheduler service and use 
the
> > scheduler internal to DP/FCM and don't use any elevated account.
> >
> >
> > -Rick Adamson
> >
> >
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
Of
> > Stefan Folkerts
> > Sent: Tuesday, June 14, 2016 5:33 AM
> > To: ADSM-L@VM.MARIST.EDU
> > Subject: [ADSM-L] MSSQL 2012 SQL permissions
> >
> > Hi all,
> >
> > Can somebody help me with the MSSQL 2012 SQL permissions that are 
needed
> > for the scheduler user?
> >
> > I can find:
> >
> >
> > https://urldefense.proofpoint.com/v2/url?
> 
u=http-3A__www-2D01.ibm.com_support_docview.wss-3Fuid-3Dswg21368503=CwIBaQ=AzgFQeXLLKhxSQaoFCm29A=eqh5PzQPIsPArLoI_uV1mKvhIpcNP1MsClDPSJjFfxw=UtpsaRjR1lo3cxWy8yN9atqFIsgPAifd7bsFQPM5HHc=7QYYsEEwqwIBQyXRYO8Ulr-65aYw-
> NXOSOFPrINsjWs=
> >
> > But that's for 2005 and it doesn't list the MSSQL permissions.
> >
> > Regards,
> >Stefan
> >
> 

Re: Restore TSM data with no TSM database.

[Shawn DREW]

Just run regular dbbackups and "prepare"'s to the data domain and you'll be 
covered.
-Shawn

This message and any attachments (the "message") is intended solely for the 
addressees and is confidential. If you receive this message in error, please 
delete it and immediately notify the sender. Any use not in accord with its 
purpose, any dissemination or disclosure, either whole or partial, is 
prohibited except formal approval. The internet can not guarantee the integrity 
of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore 
be liable for the message if modified. Please note that certain functions and 
services for BNP Paribas may be performed by BNP Paribas RCC, Inc.


Unless otherwise provided above, this message was sent by BNP Paribas, or one 
of its affiliates in Canada, having an office at 1981 McGill College Avenue, 
Montreal, QC, H3A 2W8, Canada. To the extent this message is being sent from or 
to Canada, you may unsubscribe from receiving commercial electronic messages by 
using this link: www.bnpparibas.ca/en/unsubscribe/ 
. See www.bnpparibas.ca 
 for more information on BNP Paribas, in Canada.

Re: MSSQL 2012 SQL permissions

[Shawn DREW]

Sysadmin role is required according to the documentation:

/SQLAUTHentication=INTegrated | SQLuserid
This parameter specifies the authorization mode used when logging on to the 
SQL Server. The integrated value specifies Windows authentication. The user id 
you use to log on to Windows is the same id you will use to log on to the SQL 
Server. This is the default value.

Use the sqluserid value to specify SQL Server user id authorization. The 
user id specified by the /sqluserid parameter is the id you use to log on to 
the SQL Server. Any SQL Server user id must have the SQL Server SYSADMIN fixed 
server role.

http://www.ibm.com/support/knowledgecenter/SSTFZR_7.1.4/db.sql/dps_ref_opt_backupoptional.html

This message and any attachments (the "message") is intended solely for the 
addressees and is confidential. If you receive this message in error, please 
delete it and immediately notify the sender. Any use not in accord with its 
purpose, any dissemination or disclosure, either whole or partial, is 
prohibited except formal approval. The internet can not guarantee the integrity 
of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore 
be liable for the message if modified. Please note that certain functions and 
services for BNP Paribas may be performed by BNP Paribas RCC, Inc.


Unless otherwise provided above, this message was sent by BNP Paribas, or one 
of its affiliates in Canada, having an office at 1981 McGill College Avenue, 
Montreal, QC, H3A 2W8, Canada. To the extent this message is being sent from or 
to Canada, you may unsubscribe from receiving commercial electronic messages by 
using this link: www.bnpparibas.ca/en/unsubscribe/ 
. See www.bnpparibas.ca 
 for more information on BNP Paribas, in Canada.

Re: MSSQL 2012 SQL permissions

[Stefan Folkerts]

version 7.1.4 of de SQL TDP, legacy backups. The customer doesn't want the
MSSQL sysadmin role for backup purposes.


On Tue, Jun 14, 2016 at 2:12 PM, Rick Adamson 
wrote:

> Stefan,
> Can you provide more information, like
>  -what version of SQLDP are you using
> -are you using the legacy data protection or Flash Copy Manager (FCM)
> -VSS or legacy backups
>
> On older versions I ran my scheduler with an administrator account and
> also had TSM admins added to sysadmin role in SQL in order to be able to
> troubleshoot backup issues as well as perform restores.
>
> On the releases the TSM admins still are added to the sysadmin role to
> provide support but I no longer install a scheduler service and use the
> scheduler internal to DP/FCM and don't use any elevated account.
>
>
> -Rick Adamson
>
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
> Stefan Folkerts
> Sent: Tuesday, June 14, 2016 5:33 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] MSSQL 2012 SQL permissions
>
> Hi all,
>
> Can somebody help me with the MSSQL 2012 SQL permissions that are needed
> for the scheduler user?
>
> I can find:
>
>
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www-2D01.ibm.com_support_docview.wss-3Fuid-3Dswg21368503=CwIBaQ=AzgFQeXLLKhxSQaoFCm29A=eqh5PzQPIsPArLoI_uV1mKvhIpcNP1MsClDPSJjFfxw=UtpsaRjR1lo3cxWy8yN9atqFIsgPAifd7bsFQPM5HHc=7QYYsEEwqwIBQyXRYO8Ulr-65aYw-NXOSOFPrINsjWs=
>
> But that's for 2005 and it doesn't list the MSSQL permissions.
>
> Regards,
>Stefan
>

Re: Restore TSM data with no TSM database.

[Kamp, Bruce (Ext)]

Create a VTL on the DD to back up the TSM DB & have the VTL replicate also.




Bruce Kamp
GIS Backup & Recovery
(817) 568-7331
e-mail: mailto:bruce.k...@novartis.com
Out of Office:  8/4/16-8/9/16

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Plair, 
Ricky
Sent: Tuesday, June 14, 2016 10:39 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Restore TSM data with no TSM database.

All,

I'm currently in a DR test,  and the following scenario has raised an ugly 
question.

We have a production Data Domain replicating to a DR DD.

All the data is backed up to the production DD using TSM.

The question is, can  we restore the TSM data at the DR location from the DD if 
we don't have a TSM database.

In other word,  if we lost the TSM database,  but had the data that was backed 
up by a TSM server, is there any way to build a new TSM server and retrieve the 
data.

I appreciate any help.






_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
CONFIDENTIALITY NOTICE: This email message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information and/or Protected Health Information (PHI) subject to 
protection under the law, including the Health Insurance Portability and 
Accountability Act of 1996, as amended (HIPAA). If you are not the intended 
recipient or the person responsible for delivering the email to the intended 
recipient, be advised that you have received this email in error and that any 
use, disclosure, distribution, forwarding, printing, or copying of this email 
is strictly prohibited. If you have received this email in error, please notify 
the sender immediately and destroy all copies of the original message.

Re: Restore TSM data with no TSM database.

[Skylar Thompson]

Not in any useful way, no. You need the database to (among other things)
determine where each file version lives in the storage hierarchy.

On Tue, Jun 14, 2016 at 03:39:24PM +, Plair, Ricky wrote:
> All,
>
> I'm currently in a DR test,  and the following scenario has raised an ugly 
> question.
>
> We have a production Data Domain replicating to a DR DD.
>
> All the data is backed up to the production DD using TSM.
>
> The question is, can  we restore the TSM data at the DR location from the DD 
> if we don't have a TSM database.
>
> In other word,  if we lost the TSM database,  but had the data that was 
> backed up by a TSM server, is there any way to build a new TSM server and 
> retrieve the data.
>
> I appreciate any help.

--
-- Skylar Thompson (skyl...@u.washington.edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine

Restore TSM data with no TSM database.

[Plair, Ricky]

All,

I'm currently in a DR test,  and the following scenario has raised an ugly 
question.

We have a production Data Domain replicating to a DR DD.

All the data is backed up to the production DD using TSM.

The question is, can  we restore the TSM data at the DR location from the DD if 
we don't have a TSM database.

In other word,  if we lost the TSM database,  but had the data that was backed 
up by a TSM server, is there any way to build a new TSM server and retrieve the 
data.

I appreciate any help.






_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
CONFIDENTIALITY NOTICE: This email message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information and/or Protected Health Information (PHI) subject to 
protection under the law, including the Health Insurance Portability and 
Accountability Act of 1996, as amended (HIPAA). If you are not the intended 
recipient or the person responsible for delivering the email to the intended 
recipient, be advised that you have received this email in error and that any 
use, disclosure, distribution, forwarding, printing, or copying of this email 
is strictly prohibited. If you have received this email in error, please notify 
the sender immediately and destroy all copies of the original message.

Re: MSSQL 2012 SQL permissions

[Rick Adamson]

Stefan,
Can you provide more information, like
 -what version of SQLDP are you using
-are you using the legacy data protection or Flash Copy Manager (FCM)
-VSS or legacy backups

On older versions I ran my scheduler with an administrator account and also had 
TSM admins added to sysadmin role in SQL in order to be able to troubleshoot 
backup issues as well as perform restores.

On the releases the TSM admins still are added to the sysadmin role to provide 
support but I no longer install a scheduler service and use the scheduler 
internal to DP/FCM and don't use any elevated account.


-Rick Adamson


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Stefan 
Folkerts
Sent: Tuesday, June 14, 2016 5:33 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] MSSQL 2012 SQL permissions

Hi all,

Can somebody help me with the MSSQL 2012 SQL permissions that are needed for 
the scheduler user?

I can find:

https://urldefense.proofpoint.com/v2/url?u=http-3A__www-2D01.ibm.com_support_docview.wss-3Fuid-3Dswg21368503=CwIBaQ=AzgFQeXLLKhxSQaoFCm29A=eqh5PzQPIsPArLoI_uV1mKvhIpcNP1MsClDPSJjFfxw=UtpsaRjR1lo3cxWy8yN9atqFIsgPAifd7bsFQPM5HHc=7QYYsEEwqwIBQyXRYO8Ulr-65aYw-NXOSOFPrINsjWs=
 

But that's for 2005 and it doesn't list the MSSQL permissions.

Regards,
   Stefan

MSSQL 2012 SQL permissions

[Stefan Folkerts]

Hi all,

Can somebody help me with the MSSQL 2012 SQL permissions that are needed
for the scheduler user?

I can find:

http://www-01.ibm.com/support/docview.wss?uid=swg21368503

But that's for 2005 and it doesn't list the MSSQL permissions.

Regards,
   Stefan