Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to monitor progress
Message
From
18/09/2007 14:34:30
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
18/09/2007 11:07:23
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01255135
Message ID:
01255222
Views:
10
>Hey all
>
>It's extremely easy to order SQL Server to do a backup via SPT.
>
>I can monitor it's activity by checking the resulting backup (.BAK) file size from time to time.
>
>What I want to do is obtain some kind of progress from SQL Server directly - including when the process has completed.
>
>Lots of searching on google and in the help is not proving fruitful.

You probably won't find it because it's usually very fast and nobody bothers. I've seen it dump a gigabyte in a minute or less. Haven't really measured for quite a while; I know that the backup itself is the fast part (and I'm doing truncate as well at the same time). It takes me more time to get the backup copied where it should go.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform