Need help on how to write this report.
in [Programming SQL]
|
Prev: SUM doesnt work
Next: how to use SUM
From: Lam Nguyen on 22 Jul 2008 11:18 Hi, Does anyone knows where can I get a script to generate backup and restore information like the one show below. I need to do this quick for my boss and can't think of a way to write this fast. Any helps would greatly appreciate. DatabaseName Backupstartat Backuptime Restoretime AvgFinishTime ------------------------------------------------------------------- Companydb1 8:30 PM 20 Min 150 Min 11:20 PM Testdb2 10:15 PM 2 Min 5 Min 10:22 PM Testdb3 9:30 PM 120 Min 140 Min 12:50 AM
From: Roy Harvey (SQL Server MVP) on 22 Jul 2008 11:36 What version of SQL Server are you running? It makes all the difference for this. In SQL Server 2005 I get the backup information from msdb..backupset. Roy Harvey Beacon Falls, CT On Tue, 22 Jul 2008 08:18:02 -0700, Lam Nguyen <LamNguyen(a)discussions.microsoft.com> wrote: >Hi, > >Does anyone knows where can I get a script to generate backup and restore >information >like the one show below. I need to do this quick for my boss and can't >think of a way >to write this fast. Any helps would greatly appreciate. > > >DatabaseName Backupstartat Backuptime Restoretime AvgFinishTime >------------------------------------------------------------------- >Companydb1 8:30 PM 20 Min 150 Min 11:20 PM >Testdb2 10:15 PM 2 Min 5 Min 10:22 PM >Testdb3 9:30 PM 120 Min 140 Min 12:50 AM
From: William Vaughn (MVP) on 22 Jul 2008 11:42 I would use get Visual Studio to generate a simple report that the ReportViewer control can display. -- __________________________________________________________________________ William R. Vaughn President and Founder Beta V Corporation Author, Mentor, Dad, Grandpa Microsoft MVP (425) 556-9205 (Pacific time) Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) ____________________________________________________________________________________________ "Lam Nguyen" <LamNguyen(a)discussions.microsoft.com> wrote in message news:EF99A59C-DE1C-4DC6-80FD-3C200E92EEAC(a)microsoft.com... > Hi, > > Does anyone knows where can I get a script to generate backup and restore > information > like the one show below. I need to do this quick for my boss and can't > think of a way > to write this fast. Any helps would greatly appreciate. > > > DatabaseName Backupstartat Backuptime Restoretime AvgFinishTime > ------------------------------------------------------------------- > Companydb1 8:30 PM 20 Min 150 Min 11:20 PM > Testdb2 10:15 PM 2 Min 5 Min 10:22 PM > Testdb3 9:30 PM 120 Min 140 Min 12:50 AM
From: Lam Nguyen on 22 Jul 2008 13:49 Sorry, I use SQL 2000. Thanks. "Roy Harvey (SQL Server MVP)" wrote: > What version of SQL Server are you running? It makes all the > difference for this. In SQL Server 2005 I get the backup information > from msdb..backupset. > > Roy Harvey > Beacon Falls, CT > > On Tue, 22 Jul 2008 08:18:02 -0700, Lam Nguyen > <LamNguyen(a)discussions.microsoft.com> wrote: > > >Hi, > > > >Does anyone knows where can I get a script to generate backup and restore > >information > >like the one show below. I need to do this quick for my boss and can't > >think of a way > >to write this fast. Any helps would greatly appreciate. > > > > > >DatabaseName Backupstartat Backuptime Restoretime AvgFinishTime > >------------------------------------------------------------------- > >Companydb1 8:30 PM 20 Min 150 Min 11:20 PM > >Testdb2 10:15 PM 2 Min 5 Min 10:22 PM > >Testdb3 9:30 PM 120 Min 140 Min 12:50 AM >
From: Roy Harvey (SQL Server MVP) on 22 Jul 2008 14:06
On Tue, 22 Jul 2008 10:49:03 -0700, Lam Nguyen <LamNguyen(a)discussions.microsoft.com> wrote: >Sorry, I use SQL 2000. Thanks. It turns out that in 2000 I also get the backup information from msdb..backupset. Roy Harvey Beacon Falls, CT |