|
|
-
|
|
The BACKUP team requested a report outlining the last backup of every database on every SQL Server instance, covering: full, incremental and log type backups. The idea was to compare this against their schedule, checking for differences.
The SQL Server inventory in the organisation is 750 SQL Serve......
|
|
-
|
|
Executing batch files throgh Powershell - is not doable by design. The cmd.exe is the runtime environment for .bat files, and it is
possible to issue a .bat call via the Powershell prompt
PS> cmd /c mybatchfile.bat
Republished from <a href="http://www.sqlserver-dba.com/">http://www.sqlserver-dba......
|
|
-
|
|
There was a requirement to add a SQL Server login to a group of SQL Servers.
The SQL Server login was to be uniform across all the servers. I tend to use SQLCMD for most
DBA tasks - and as my account is Windows based and with high level of privileges,
I didn't
have to worry about supplying......
|
|
-
|
|
The Tivoli Monitoring agent requires the Error Log Path and the SQL Server Home Path, for installation
My first problem was to derive the t-sql to gain the information for one sql server instance.
The second problem was to use a scripting framework to iterate through every sql server instance ......
|
|
-
|
|
In an environment where I do not have 100% control over what files are saved in what location, I will often have issues with various application owners creating ad-hoc BAK files. This develops into a disk - space issue, causing data and log files to have no more room to grow I use the script below t......
|
|
-
|
|
Running the code below within the Powershell interface will list designated Errors Log messages instances (SQL SERVER 2005) listed in the "C:\InstancesPROD_2005.txt" document.
An example of the lists in that document is:
SERVER1\INST1
SERVER2\INST2
etc
Currently the sql code will designated ......
|
|
-
|
|
Running the code below within the Powershell interface will list all SQL Server jobs failed
on instances (SQL SERVER 2000 & SQL SERVER 2005) listed in the "C:\Instances.txt" document.
An example of the lists in that document is:
SERVER1\INST1
SERVER2\INST2
etc
Currently the sql code wi......
|
|