EMC NetWorker Module for Microsoft SQL Server 5.2 1 P/N 300-008-657 REV A01 EMC 2-1-1 151-0053 0120-588543 9:00 17:30 URL http://japan.emc.com
Copyright 1996-2009 EMC Corporation. All rights reserved. 2009 5 EMC Corporation EMC EMC Powerlink Technical Documentation and Advisories EMC EMC.com EMC Corporation Trademarks 2 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
... 5 1 2 NetWorker Module for SQL Server... 10 NetWorker PowerSnap... 11... 14 NetWorker... 14... 14... 15... 15 Microsoft SQL Server... 15 NetWorker PowerSnap Module... 16 NetWorker... 17 NetWorker... 17... 18... 19 NetWorker... 20... 20... 21 NetWorker... 22 NetWorker Module... 23... 23... 23 Microsoft... 26 Microsoft... 26... 28 NetWorker... 28... 29 NetWorker... 29... 30... 30 NetWorker Module... 32... 32... 33... 34 NetWorker... 35 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1 3
... 35... 35 3 A NetWorker... 38 NetWorker Module for Microsoft SQL Server... 38... 39... 39... 39... 40 Powerlink NetWorker... 40... 43... 45 NetWorker... 45... 45... 46... 46... 46... 47 HomeBase Server HomeBase Agent... 47... 47 Windows Server 2003 NetWorker Module... 50... 51 4 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
EMC EMC EMC NetWorker Module for Microsoft SQL Server EMC NetWorker Microsoft SQL Server 2000 2005 2008 NetWorker EMC NetWorker Module for Microsoft SQL Server EMC NetWorker Module for Microsoft SQL Server EMC NetWorker Module for Microsoft SQL Server Release Notes EMC NetWorker Module for Microsoft SQL Server EMC NetWorker PowerSnap Module Installation and Administrator s Guide NetWorker EMC NetWorker EMC NetWorker EMC NetWorker Release Notes http://powerlink.emc.com EMC NetWorker Module for Microsoft SQL Server 5.2 SP1 5
EMC!! SQL URL Courier URL Courier Courier < > [ ] { } x y z... 6 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
EMC EMC EMC Powerlink Web http://powerlink.emc.com Powerlink EMC Powerlink EMC SSGdocumentation@EMC.com EMC NetWorker Module for Microsoft SQL Server 5.2 SP1 7
8 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
1 NetWorker Module for SQL Server 10 NetWorker PowerSnap 11 9
NetWorker Module for SQL Server EMC NetWorker Module for Microsoft SQL Server 5.2 SP1 NetWorker Microsoft SQL Server 2008 Microsoft SQL Server 2005 Microsoft SQL Server 2000 Microsoft SQL Server NetWorker UNIX Microsoft Windows NetWorker Module for Microsoft SQL Server NetWorker SQL Server 10 1 SQL NSR libbsa.dll sqlvdi.dll nwmssql.exe nsrsqlrc.exe NetWorker Server SQL Microsoft NetWorker User for SQL Server / nsrsqlsv.exe libbsa.dll NSR nsrexecd NetWorker Module for SQL Server 1 SQL Server NetWorker NetWorker Module for Microsoft SQL Server / Windows Server 2000 Windows Server 2003 Windows Server 2008 SQL Server 2000 2005 2008 / 10 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
NetWorker PowerSnap NetWorker Module for Microsoft SQL Server NetWorker PowerSnap Module NetWorker NetWorker Module for Microsoft SQL Server EMC SQL Server NetWorker PowerSnap Microsoft SQL Server PIT PowerSnap Module EMC NetWorker PowerSnap Module NetWorker PowerSnap 11
12 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
2 14 15 18 19 NetWorker 20 NetWorker 22 NetWorker Module 23 Microsoft 26 28 NetWorker Module 32 NetWorker 35 13
NetWorker Module for Microsoft SQL Server 1. 15 2. 18 3. NetWorker 22 4. NetWorker NetWorker Module 23 5. NetWorker 3 NetWorker NetWorker Module for Microsoft SQL Server IPv6 NetWorker IPv6 NetWorker 7.5 NetWorker Module for SQL Server NetWorker 7.5 NetWorker 7.5 NetWorker NetWorker Module DVD NetWorker NetWorker Module for Microsoft SQL Server NetWorker 7.4 14 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
NetWorker Module for Microsoft SQL Server Microsoft Windows Windows 2000 Windows Server 2003 Windows Server 2008 SQL Server Microsoft Windows SQL Server 15 Microsoft SQL Server NetWorker Module for Microsoft SQL Server Microsoft SQL Server Microsoft SQL Server 2008 Express Workgroup Standard Web Compact Enterprise Microsoft SQL Server 2005 Express Workgroup Standard Enterprise Microsoft SQL Server 2000 Standard Enterprise Microsoft Windows SQL Server NetWorker Module for Microsoft SQL Server 15 1 Microsoft Windows Microsoft SQL Server 1 NetWorker Module SQL Server Windows Server SQL Server 2008 x86 x64 SQL Server 2005 x86 x64 2 Windows Server 2008 x86 x64 Windows Server 2008 Enterprise Windows Server 2008 Datacenter SQL Server 2008 x86 x64 IA64 SQL Server 2005 x86 x64 IA64 2 SQL Server 2000 x86 IA64 4 KB913100 Windows Server 2003 R2 x64 x86 IA64 Windows Server 2003 x64 x86 IA64 Windows 2000 x86 Windows Server 2003 R2 x64 x86 IA64 Windows Server 2003 x64 x86 IA64 Windows 2000 x86 Windows Server 2003 Enterprise Windows Server 2003 Datacenter Windows 2000 Advanced Server Windows 2000 Datacenter Server Windows Server 2003 Enterprise Windows Server 2003 Datacenter Windows 2000 Advanced Server Windows 2000 Datacenter Server 15
Windows Server 2003 x64 SQL Server NetWorker WOW64 SQL Server SQL Server 2000 Virtual Device Interface Sqlvdi.dll 32 DLL SQL Server 2000 Windows Server 2003 x64 Microsoft Windows Server 2003 x64 64 VSS Sqlvdi.dll x64 Microsoft http://support.microsoft.com/kb/913100/ NetWorker PowerSnap Module NetWorker PowerSnap NetWorker Module for Microsoft SQL Server / PowerSnap SQL Server SQL Server PowerSnap SQL Server PowerSnap SQL Server PowerSnap NetWorker 7.4 PowerSnap 2 NetWorker Module for SQL Server 5.2 SP1 2 NetWorker Module PowerSnap SQL Server SQL Server 2008 x86 SQL Server 2005 x86 SQL Server 2000 x86 Windows Server 2003 R2 x86 Windows Server 2003 x86 PowerSnap PowerSnap for Symmetrix DMX SQL Server 2008 x86 x64 SQL Server 2005 x86 x64 SQL Server 2000 x86 Windows Server 2003 R2 x86 PowerSnap for CLARiX x64 Windows Server 2003 x86 x64 SQL Server 2008 x86 SQL Server 2005 x86 SQL Server 2000 x86 Windows Server 2003 R2 x86 Windows Server 2003 x86 PowerSnap for RecoverPoint PowerSnap EMC 16 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
NetWorker NetWorker SQL Server NetWorker EMC NetWorker NetWorker Module for Microsoft SQL Server NetWorker NetWorker 7.4 Windows Server 2008 SQL Server 2008 NetWorker 7.4.2 NetWorker 7.4 nsr_render_log 7.4 EMC NetWorker 7.5 IPv6 NetWorker 7.5 NetWorker Module for Microsoft SQL Server NetWorker SQL Server 2008 Microsoft SQL Server 2005 NetWorker SQL-DMO SQL Server SQL Server 2008 SQL-DMO http://www.microsoft.com/downloads/ NetWorker Module NetWorker Module for SQL Server 4.0 NetWorker NetWorker_install_path NetWorker NetWorker NetWorker %SystemDrive%\Program Files\Legato\nsr 17
NetWorker Module for Microsoft SQL Server SQL Server 15 SQL Server 3 32 - NetWorker Module 6.8 MB 6.0 MB 896 KB 4 x64 - NetWorker Module 9.1 MB 8.3 MB 896 KB 5 ia64 15.6 MB NetWorker SQL Server 5.2 SP1 Windows 18 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
NetWorker Module for Microsoft SQL Server! NetWorker User for SQL Server NetWorker User for SQL Server 2 Windows 1. NetWorker Module for Microsoft SQL Server CD 2. setup.exe 3. 4. Microsoft 19
NetWorker NetWorker NetWorker Module for Microsoft SQL Server SQL Server NetWorker SQL Server NetWorker NetWorker NetWorker NetWorker NetWorker NetWorker Module for Microsoft SQL Server SQL Server NetWorker SQL Server NetWorker NetWorker NetWorker SQL Server NetWorker SQL Server NetWorker NetWorker EMC NetWorker NetWorker 20 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
21 2 NetWorker SQL Server NetWorker Microsoft SQL Server NetWorker Client for Windows NetWorker Module for Microsoft SQL Server PowerSnap NetWorker Windows UNIX NetWorker for Windows NetWorker for UNIX 2 NetWorker 21
NetWorker NetWorker Module for Microsoft SQL Server CD 1. SQL Server NetWorker Module for Microsoft SQL Server CD 2. CD 3. SQL Server Windows 4. Windows CD 5. NetWorker Module 23 EMC Web 1. Web http://japan.emc.com 2. Evaluation Software Request 3. Search by Product NetWorker Module for Microsoft SQL Server 5.2 SP1 4. Evaluation Software Request EMC FTP NetWorker URL 5. 6. Web 7. NetWorker 8. 23 22 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
NetWorker Module 1 Microsoft SMS Systems Management Server Microsoft 26 Microsoft Microsoft 26 NetWorker 23 NetWorker NetWorker Module for Microsoft SQL Server 1. NetWorker 2. NetWorker SQL Server 2008 Microsoft SQL Server 2005 NetWorker SQL-DMO SQL Server SQL Server 2008 SQL-DMO http://www.microsoft.com/downloads/ 3. NetWorker Module for Microsoft SQL Server 4. NetWorker Module for Microsoft SQL Server /nsr/res/servers NetWorker_install_path\res\servers servers servers NetWorker Module for Microsoft SQL Server 1. 15 2. 18 3. 4. NetWorker 5. Windows NetWorker Module for Microsoft SQL Server CD setup.exe EMC Web nmsql521_win_x86.exe 32 nmsql521_win_x64.exe x64 nmsql521_win_ia64.exe ia64 NetWorker Module 23
6. NetWorker Module for Microsoft SQL Server 7 NetWorker Module 9 34 35 7. 8. Microsoft SQL Server NetWorker Module for Microsoft SQL Server Microsoft SQL Server OK 9. NetWorker 11 NetWorker NetWorker Server setup.exe NetWorker Module 32 10. 9 11 NetWorker Server SQL Server NetWorker Server 24 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
a. NetWorker Module for Microsoft SQL Server b. 11. SQL Server NetWorker NetWorker NetWorker NetWorker NetWorker 12. 13. Windows NetWorker NetWorker User for SQL Server <NetWorker_install_path>\bin NetWorker NetWorker 17 14. InstallShield Wizard NetWorker Module 25
Microsoft NetWorker Module for Microsoft SQL Server Microsoft Microsoft Cluster Server MSCS / SQL Server / SQL Server 2000 2005 2008 / NetWorker NetWorker Module for Microsoft SQL Server SQL Server Microsoft Microsoft MSCS NetWorker Module for Microsoft SQL Server 1. NetWorker NetWorker NetWorker NetWorker NetWorker_install_path\res\servers Microsoft servers servers NetWorker servers EMC NetWorker NetWorker servers NetWorker 2. NetWorker NetWorker Module 23 26 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
3. 3 4. SQL Server NetWorker PowerSnap Microsoft EMC NetWorker PowerSnap Module Microsoft 27
NetWorker Module for Microsoft SQL Server SQL Server NetWorker NetWorker Module for Microsoft SQL Server SQL Server NetWorker SQL Server NetWorker NetWorker NetWorker Module for Microsoft SQL Server SQL Server NetWorker SQL Server 29 NetWorker 29 28 6 6 NetWorker Administrator NetWorker NetWorker NetWorker EMC NetWorker EMC NetWorker Module for Microsoft SQL Server NetWorker Windows NetWorker Administrator UNIX EMC NetWorker UNIX/Linux 28 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
NetWorker 1. NetWorker 2. 3. 4. 5. 6. 3 33 1 7. 8. 9. Advanced 10. 11. OK NetWorker NetWorker Administrator SQL Server NetWorker NetWorker 1 Microsoft SQL Server NetWorker NetWorker UNIX domain\username SQL SQL 29
NetWorker 1. NetWorker Management Console 2. 3. 4. SQL Server DNS 5. SQL Server MSSQL: MSSQL$<instancename>:db_name 6. 7. 8. 9. 10. 11. 1/2 DNS nsrsqlsv 12. OK NetWorker EMC NetWorker EMC NetWorker Module for Microsoft SQL Server SQL Server NetWorker Module for Microsoft SQL Server NetWorker 30 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
NetWorker NetWorker! NetWorker Administrator SQL Server NetWorker 1 9 1. 2. 3. 4. NetWorker 31
NetWorker Module NetWorker Module for Microsoft SQL Server NetWorker Module for Microsoft SQL Server 1. 2. NetWorker 3. Windows setup.exe 4. NetWorker Module for Microsoft SQL Server InstallShield NetWorker Module for Microsoft SQL Server 3 5. 32 NetWorker Module for Microsoft SQL Server 64 64 SQL Server / 34 32 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
Windows NetWorker 35 NetWorker Module for Microsoft SQL Server 1. Windows setup.exe 2. 3. 4 4. 5. NetWorker User for SQL Server NetWorker NetWorker NetWorker User for Exchange Server 6. NetWorker Module 33
NetWorker Module for Microsoft SQL Server 1. Windows setup.exe 2. 3. 34 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
NetWorker NetWorker Module for Microsoft SQL Server Windows NetWorker Module for Microsoft SQL Server 1. Windows setup.exe 2. 3. 4. Windows NetWorker Module for Microsoft SQL Server 1. Windows 2. 3. NetWorker Module for Microsoft SQL Server 4. NetWorker 35
36 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
3 NetWorker 38 NetWorker Module for Microsoft SQL Server 38 40 NetWorker 45 46 47 37
NetWorker NetWorker 30 NetWorker NetWorker NetWorker NetWorker NetWorker NetWorker Module for Microsoft SQL Server NetWorker Module for SQL Server 2 1 SQL Server MSCS - 1 SQL 1 NetWorker Module - NetWorker Module for SQL Server SQL 2 4 SQL 4 SQL 4 NetWorker Module SQL Server SQL 1 NetWorker Module 1 10.0.000.100 SQL Server -> 1 SQL Server SQL 1 SQL /IP NMSQL 1 10.0.000.101 SQL Server -> 1 2 10.0.000.102 SQL Server -> 1 3 10.0.000.103 SQL Server -> 1... SQL Server LAN 38 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
NetWorker 2 NetWorker NetWorker NetWorker 30 NetWorker NetWorker 1 NetWorker Module 45 Web http://powerlink.emc.com EMC Information Protection and Availability Product Families Media Kit NetWorker 15 NetWorker NetWorker 40 NetWorker 7.3 1. 2. a. b. 39
c. d. 3. 4. 5. 6. 7. 8. OK NetWorker NetWorker 45 NetWorker NetWorker Module for Microsoft SQL Server 38! EMC Powerlink NetWorker 43 Powerlink NetWorker NetWorker EMC Powerlink Licensing NetWorker License Manager EMC Powerlink Licensing NetWorker NetWorker NetWorker NetWorker License Manager EMC Powerlink 1. EMC Powerlink Web http://powerlink.emc.com 2. Licensing D-Q NetWorker Powerlink Licensing Home 40 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
LAC ID EMC E 3. Powerlink Licensing Home NetWorker Tools Download Enabler Code Search for Download Enabler Codes 4. %HostID ID 5. Search Search for Download Enabler Codes 6. ID Download 7. Download Enablers Download CSV Download nsradmin Download ReadMe 3 ReadMe nsradmin ReadMe_<HostID>_<Date>.txt ReadMe_df010b3f_20080814.txt nsradmin nsradmin <HostID><date>.nsradmin df010b3f_20080814.nsradmin CSV Excel <hostid>.csv df010b3f.csv Powerlink NetWorker 1. NetWorker Windows Linux UNIX Windows Administrator UNIX Linux:root 2. 41
3. source_file nsradmin nsradmin NetWorker NetWorker NetWorker nsradmin -i source_file > output_file NetWorker NetWorker nsradmin -i source_file -s server_name > output_file NetWorker License Manager nsradmin -i source_file -s server_name -p lgtolmd > output_file 4. output_file NetWorker C:\PROGRA~1\Legato\nsr\bin\std>nsradmin -i infile created resource id 25.0.0.20.96.108.23.72.137.69.168.135(1) Current query set updated resource id 25.0.0.20.96.108.23.72.137.69.168.135(2) NetWorker C:\PROGRA~1\Legato\nsr\bin\std>nsradmin -i infile : xxxxxx-xxxxxx-xxxxxx Current query set updated resource id 25.0.0.20.96.108.23.72.137.69.168.135(3) nsradmin NetWorker NetWorker NetWorker NetWorker C:\PROGRA~1\Legato\nsr\bin\std>nsradmin -i infile pasb-tomp 39078:nsradmin:RPC : 4 15 EMC NetWorker EMC http://powerlink.emc.com 42 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
1. NetWorker 7.3 43 2. 44 3. 44 NetWorker 7.3 1. 2. a. b. c. d. 3. 4. 5. 6. 7. 8. OK 1 8 45 NetWorker 15 NetWorker NetWorker 43
! http://powerlink.emc.com 45 45 - http://powerlink.emc.com ID ID NetWorker License Manager NetWorker License Manager 47 NetWorker License Manager 1. 2. a. b. c. d. 3. 4. 5. 6. 7. 8. OK 44 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
1 1 7.5 NetWorker NetWorker 7.5 ea7e6c-a61631-bf0db0! NetWorker 7.5 45 EMC NetWorker NetWorker EMC 2 / NetWorker 1 64 FQDN IP NetWorker 45
NetWorker Module NetWorker Module 1 1 SQL Exchange SharePoint Oracle SAP 1 NetWorker Module VM NetWorker 7.5 VM VM VMware Consolidated Backup VCB VMware Consolidated Backup 1 NDMP ClientPak 46 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
1 HomeBase Server HomeBase Agent HomeBase Server HomeBase Agent HomeBase EMC HomeBase Server EMC HomeBase Agent NetWorker License Manager 1 NetWorker License Manager IP NetWorker License Manager NetWorker License Manager 1. http://powerlink.emc.com 2. NetWorker License Manager 3. NetWorker License Manager 4. NetWorker License Manager NetWorker NetWorker License Manager NetWorker License Manager 47
48 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
A Windows Server 2003 Windows Server 2003 NetWorker Module for Microsoft SQL Server NetWorker Module 50 Windows Server 2003 49
Windows Server 2003 NetWorker Module Windows Server 2003 NetWorker Module for Microsoft SQL Server NetWorker NetWorker Module for Microsoft SQL Server NetWorker Module for Microsoft SQL Server 1. NetWorker Module for Microsoft SQL Server applogs C:\Program Files\Legato\nsr\applogs 2. HKLM\Software\Legato\BSMSQL\Environment HKLM\Software\Microsoft\DataAccess HKLM\Software\Microsoft\MSSQLServer HKLM\Software\Microsoft\Microsoft SQL Server WOW64 64 32 SQL Server HKLM\Software\Wow6432Node\Microsoft\MSSQLServer HKLM\Software\Wow6432Node\Microsoft\Microsoft SQL Server 3. SQL VDI SQL Server sysadmin Microsoft SQL Server 50 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1
M Microsoft 26 N NetWorker Module 28 NetWorker 17 P PowerSnap Module 11 S SQL Server NetWorker 10 10 15 W Windows Server 2003 50 15 29 29 29 30 33 32 19 17 32 18 ia64 18 Microsoft 26 x64 18 28 20 18 22 33 32 14 35 17 14 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1 51
52 EMC NetWorker Module for Microsoft SQL Server 5.2 SP1