Re: MSSQL 2012 SQL permissions

2016-06-14 Thread 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 >

Re: MSSQL 2012 SQL permissions

2016-06-14 Thread 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 >

Re: Restore TSM data with no TSM database.

2016-06-14 Thread 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 u

Re: MSSQL 2012 SQL permissions

2016-06-14 Thread 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 s

Re: MSSQL 2012 SQL permissions

2016-06-14 Thread 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 pr

Re: Restore TSM data with no TSM database.

2016-06-14 Thread 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 P

Re: Restore TSM data with no TSM database.

2016-06-14 Thread 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

Restore TSM data with no TSM database.

2016-06-14 Thread 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

Re: MSSQL 2012 SQL permissions

2016-06-14 Thread 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 SQ

MSSQL 2012 SQL permissions

2016-06-14 Thread 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