Backup Text Report - Microsoft SQL Server

acko bogicevic

Hi
How can i make textreports after backup with t-sql without using
Database Maintenance Plan.
thanks
alex

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #1

Subscribe Post Reply

1774

Simon Hayes

"acko bogicevic" <ac*******@yahoo.com> wrote in message
news:40*********************@news.frii.net...

Hi
How can i make textreports after backup with t-sql without using
Database Maintenance Plan.
thanks
alex

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

That depends what information you want. If you're scheduling your own backup
jobs, you can send the output to a log file, but if you want more detailed
information, then you'd have to write your own script to do this.

Simon

Jul 20 '05 #2

Simon Hayes

"acko bogicevic" <ac*******@yahoo.com> wrote in message
news:40*********************@news.frii.net...

Hi
How can i make textreports after backup with t-sql without using
Database Maintenance Plan.
thanks
alex

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #3

acko bogicevic

Have you some examples of those scripts?
acko

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #4

acko bogicevic

Have you some examples of those scripts?
acko

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #5

Simon Hayes

"acko bogicevic" <ac*******@yahoo.com> wrote in message
news:40*********************@news.frii.net...

Have you some examples of those scripts?
acko

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

No, but if you can explain what information you need to log, and why the
maintenance plan reports aren't good enough, then someone may be able to
suggest something specific. It might be easiest to use a script in Perl,
VBScript, VB, C# etc., because they can manipulate text files much more
easily than pure TSQL.

Simon

Jul 20 '05 #6

Simon Hayes

"acko bogicevic" <ac*******@yahoo.com> wrote in message
news:40*********************@news.frii.net...

Have you some examples of those scripts?
acko

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #7

acko bogicevic

I want the same informations as DMPlan would create but without usint
DMPlan.
acko

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #8

Simon Hayes

"acko bogicevic" <ac*******@yahoo.com> wrote in message
news:40*********************@news.frii.net...

I want the same informations as DMPlan would create but without usint
DMPlan.
acko

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

One way would be to write your own script(s) using the SQLDMO COM objects,
in a language like Perl, VBScript etc. But I don't know why you would want
to do that when the maintenance plan will do it for you.

Simon

Jul 20 '05 #9

acko bogicevic

I want the same informations as DMPlan would create but without usint
DMPlan.
acko

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #10

Simon Hayes

"acko bogicevic" <ac*******@yahoo.com> wrote in message
news:40*********************@news.frii.net...

I want the same informations as DMPlan would create but without usint
DMPlan.
acko

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #11

Similar topics

Backup failure Error Log Messages

by: Stephanie | last post by:

I have not been able to find any details about backup failures for MSSQL 2000. I am researching the following: 1. when a backup fails at a certain point during the process does the backup: A....

Microsoft SQL Server

Need help with an automated backup process problem.

by: ChrisWinterscheid | last post by:

We are running DB2 8.1 on AIX 5.2. DB2level shows: DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08016" with level identifier "02070106". Informational tokens are "DB2...

DB2 Database

SQLDMO.Backup and ProgressBar

by: | last post by:

Hi all My requirement is to "on button_click, backup a SQL database using SQLDMO.Backup object and update the progress in a ProgressBar. The problem is the progress bar does not update at all...

C# / C Sharp

SQLDMO.Backup and ProgressBar - help please

by: | last post by:

Hi all, continued from yesterday's posting... I still haven't found a solution to this issue. I put a breakpoint in private void SqlBackupPercentComplete(string message, int Percent) {...

C# / C Sharp

SQLDMO.Backup and ProgressBar - help needed

by: | last post by:

Hi all I am posting this to check if anyone could help me. The problem still persists. I am beginner in C#. Thanks. Subject: SQLDMO.Backup and ProgressBar - help please From: ...

C# / C Sharp

How backup or copy form

by: Woody Splawn | last post by:

I am somewhat new to VS.net in general. As a result I am prone to make mistakes. When adding some new feature to a a form it would be nice if I could back it up before trying something that might...

Visual Basic .NET

Using SQL Server 7.0, Backup maintenance plan not working

by: microsoft . public . sqlserver | last post by:

I am using SQL server 7.0. After restoring all the databses (Except distribution) Everything seems to be working fine except the backup maintenance plan. I put following detail in the maintenance...

Microsoft SQL Server

Error after importing forms from backup copy of project

by: Mark | last post by:

Good morning. I recently made some changes to my Access project, and I introduced some problems that I could not resolve. So I deleted the forms that I had altered and saved the project. Then I...

Microsoft Access / VBA

does this backup sequence commit all data to the database

by: Roger | last post by:

backup log testdb with truncate_only DBCC SHRINKFILE (testdb_log, 100) WITH NO_INFOMSGS backup database testdb to disk = '\\DC01\Backups\DB01\testdb.bak' with init and does the shrinkfile...

Microsoft SQL Server

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice