Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Chad Miller Database Space Capacity Planning RE: Database Space Capacity Planning

  • October 14, 2009 at 8:12 am

    #1065703

    graeme.black (10/14/2009)

    Hi

    I am stepping thorugh the various steps, but when I try to launch the powershell scripts, I get the following error

    C:\BIN>WRITE-DBSPACETODB.PS1

    Exception calling "Fill" with "1" argument(s): "Invalid object name 'server_spa

    ce_lku'."

    At C:\BIN\Write-DbSpaceToDb.ps1:13 char:15

    + [void]$da.fill( <<<< $dt)

    I have the following entry in 'Server_space)lku'

    servname\instance

    You need specifiy both a server name and database name, where server name is the SQL Server instance where your spacedm database is located and database is your space dm database. The script should be called like this:

    Write-dbspacetodb.ps1 Z002\SQL2K8 spacedm