Post reply

DB Script

  • October 31, 2007 at 3:41 am

    #119131

    Hi Guys,

    Does anyone perhaps have a script that displays the Database file that was backup up.

    We are currently doing backups and they are being stored on a remote server. We need a script that will tell us the names of the backups files and on which date they were backed up.

    Regards

    IC

  • October 31, 2007 at 3:56 am

    #746969

    Sorry, I don't have a ready made script but if you query msdb.. backupset and msdb..nbackupfile you can find all the information you need.

    [font="Verdana"]Markus Bohse[/font]

  • October 31, 2007 at 3:59 am

    #746972

    Thanks, I found a script that can do it. I just need to alter it a bit

  • October 31, 2007 at 4:22 am

    #746981

    Use my utility to generate DDL script for SQL Server Database.

    Note: This utility requires, SQL Server 2005 and .NET 2.0 (Developed in C#.NET 2005 & SQL Server 2005)

    🙂

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

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