Muthusamy Anantha Kumar

(“Microsoft.AnalysisServices”) >$NULL $server = New-Object Microsoft.AnalysisServices.Server $server.connect(“PowerServer3\SQL2008”) Note: PowerServer3 is the hostname and SQL2008 is the Analysis Service instance name. We now know the different options available in the restore method. You can see the value information from the restore method. [Refer Figure 1.2] $server.restore Click for larger image Figure 1.2 From the above cmdlet’s […]

Note: PowerServer3 is the hostname and SQL2008 is the Analysis Service instance name. From part V of this article, we know that the backup method is defined under object database. However, the restore method is defined under object Server. Let’s query all of the options available under server object. This can be achieved by using […]

Part 1 of this article series “Microsoft Windows PowerShell and SQL Server 2008 AMO” illustrated how to install Windows PowerShell and connect to an Analysis Service Servername. Part 2 illustrated how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service. Part 3 discussed how to use Windows […]

Be advised that this article is intended for a test environment, not for production! Part 1 of this article series “Microsoft Windows PowerShell and SQL Server 2008 AMO” illustrated how to install Windows PowerShell and connect to an Analysis Service Servername. Part 2 [of this article illustrated how to use Windows PowerShell and AMO to […]

Part I of this article series “Microsoft Windows PowerShell and SQL Server 2008 AMO” illustrated how to install Windows PowerShell and connect to an Analysis Service Servername. Part II illustrated how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service. Part III of this article discusses how […]

Part I of this article series “Microsoft Windows PowerShell and SQL Server 2008 AMO” illustrated how to install Windows PowerShell and connect to an Analysis Service Servername. Part II of this article illustrates how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service. Let’s connect to Analysis […]

As you probably know, Windows PowerShell is the new command shell and scripting language that provides a command line environment for interactive exploration and administration of computers. In addition, it provides an opportunity to script these commands so that we can schedule and run these scripts multiple times. Windows PowerShell depends on .NET framework 2.0 […]

» See All Articles by Columnist MAK

Part I of this series illustrated the first and most important check on SQL Server–how to ping the host. Part 2 examined how to check all of the windows services related to SQL Server and part 3 discussed how to check the hardware and operating system information. Part 4 illustrated how to get hard disk […]

» See All Articles by Columnist MAK

»

Database administrators are often required to terminate the user process in situations such as de-comissioning a database, before restoring a database or long running open transactions, etc. In all of these cases they would use the “KILL” command provided in SQL Server. The “KILL” command provided by SQL Server is not flexible enough to kill […]