Post reply

Backup only SQL Server 2005 and Analisis Server 2005 database estructure

  • July 1, 2009 at 1:40 am

    #206120

    Hi,

    I would like schedule backups of only the STRUCTURE of the databases existing in my SQL Server 2005 and Analysis Server 2005 servers.

    To do backups of the structure of the databases existing in SQL Server 2005 server i could use the 'Database_Publishing_Wizard' tool. This tool generates script to all the objects of the data bases, but it does not generate the database definition and structure script (with the information of filegroups, files, …). Somebody could indicate to me how i could obtain this information in a script?

    At the same time somebody could indicate to me how i could get my Analysis Services 2005 databases structure scrìpt? How i could get a script with the same .xmla information that i can get when i get it manually from the SSMS?

    Thank you very much.

  • July 1, 2009 at 12:49 pm

    #1018656

    This http://www.sqlservercentral.com/scripts/attach/66866/ is in the script section and is worth a look for scripting databases.

    Greg

  • July 2, 2009 at 12:45 am

    #1018933

    Hi,

    Thanks for you reply Greg. It is very interesting script.

    But it does not allow me to obtain the full structure info of the database, that is, i can't get the same information that i can obtain when i generated database create script from SSMS. For example i can't get the FILEGROUPS info, or the files properties (size, maxsize…) ...

    Thanks Greg.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply