28 Kasım 2016 Pazartesi

nbdeployutil

nbdeployutil

deployment utility that gathers and analyzes master server information regarding clients and capacity

/usr/openv/netbackup/bin/admincmd/nbdeployutil --gather


/usr/openv/netbackup/bin/admincmd/nbdeployutil --report --capacity "/path/path1/tarih_saat_mastersername"

# nbdeployutil.exe --gather --output pickedclient --start "11/01/10 
06:00:00" --end "11/02/10 01:00:00" --clients marybl2g1,marybl7g1  /
--verbose NetBackup Deployment Utility, version 7.1.0000.0000
Gathering license deployment information...
run: bpgetconfig
  Discovered master server marybl2g1
run: bpimagelist -M marybl2g1 -d "11/01/10 06:00:00" -e "11/02/10 
01:00:00" -l -client marybl2g1
run: bpimagelist -M marybl2g1 -d "11/01/10 06:00:00" -e "11/02/10 
01:00:00" -l -client marybl7g1
  Output for marybl2g1 at: pickedclient\20101102_155246_marybl2g1
Gather DONE
Execution time: 4 secs
To create a report for this master server, run the following:
  nbdeployutil.exe --report "pickedclient\20101102_155246_marybl2g1"

D:\># nbdeployutil.exe --report --capacity pickedclient\
20101102_154010_marybl2g1 --start "11/01/10 06:00:00" 
--end "11/02/10 01:00:00" --clients marybl2g1,
marybl7g1 --verbose
NetBackup Deployment Utility, version 7.1.0000.0000
Analyzing license deployment ...
  Master marybl2g1
  Report created at: pickedclient\20101102_154010_marybl2g1\
  report-20101102_155414.xls
Analysis DONE
Execution time: 2 secs

https://www.veritas.com/support/en_US/article.000110120


24 Kasım 2016 Perşembe

MS-SQL / Commands

SELECT * FROM  sys.sysprocesses order by hostname;

SELECT * FROM  sys.sysprocesses order by loginame;


Restore sonrası kullancı açılması ile db üzerined çalıştırılacak komut:

sp_change_users_login 'AUTO_FIX', 'user_name'


SQL DB OFFLINE FORCE:

USE master
GO
ALTER DATABASE DB_NAME
SET Offline WITH ROLLBACK IMMEDIATE
GO

18 Kasım 2016 Cuma

MS-SQL / delete tempdb file


USE tempdb
GO
DBCC SHRINKFILE (tempdb4, EMPTYFILE);
GO


USE tempdb;
GO
DBCC SHRINKFILE('tempdb4', EMPTYFILE)
GO
USE master;
GO
ALTER DATABASE tempdb
REMOVE FILE tempdb4;

10 Kasım 2016 Perşembe

the specified client does not exist in the specified policy(239) / SAP BAckup

the specified client does not exist in the specified policy(239)

Sunucu üzerinde oracle\SID\dbversion\database\initSID.utl dosyası düzenlendi

Dosya içerisindeki Client SERVERNAME değerini politikada yazan ile değiştirildi

Windows Server IIS üzerinden hizmet veren bir FTP servisine erişmek istediğimizde;  Internet Explorer, FileZilla vb. uygulamalar ile erişim ...