Max Wanadoo
max.wanadoo at gmail.com
Thu Mar 11 18:51:13 CST 2010
I am going to learn PowerBasic next. Once I have finished the Blat Form program (and that is nearly there) I want to put it into an .exe and from what I read on the PB site, it should be pretty straight forward with their Forms module. I did Quick Basic (Qbasic) some years back and that was very powerful without a too steep learning curve. C# is OTT for my needs. Max -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, March 11, 2010 8:51 PM To: Discussion concerning Visual Basic and related programming issues. Subject: Re: [dba-VB] Backups and the art of Zen > As least your c# is coming on a-pace. LOL, it is indeed. I started taking a C# class at the local community college last fall semester (sept). At that time I couldn't do much of anything in C# directly. Since then I have done hundreds of hours in C# and am finally feeling somewhat comfortable in it. I live by example code. I get something running and then look back at that to see how I did it before. It sure wouldn't be the same without the internet though. I have learned so much from googlin stuff. I have to also say that the state of the art in .Net and SQL Server has advanced so much in just the last 5 years. AMAZING! John W. Colby www.ColbyConsulting.com Max Wanadoo wrote: > Never mind John, > > As least your c# is coming on a-pace. > > Max > > > -----Original Message----- > From: dba-vb-bounces at databaseadvisors.com > [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Thursday, March 11, 2010 8:33 PM > To: VBA; Dba-Sqlserver > Subject: [dba-VB] Backups and the art of Zen > > I spent many hours searching for a free SQL Server backup tool (Idera) > and writing stored procedures to automatically back up all of my > databases, mount them, unmount them etc., from C#. > > Then I updated to SQL Server 2008 and it all broke. The Idera Free > backup was a DLL and apparently it is simply incompatible with SQL Server 2008. > Sigh. > > Luckily my other server still has 2005 installed so... I need to get > all of my backups restored to > 2005 so that they are available in case I need them, then write them > back out using 2008 and its wonderful compression. I have written C# > code to do that, so once I get the backups restored I should be able > to re-backup using the latest and greatest and don't even need the > Idera Free backup > - which is a good thing since it has since gone away entirely. > > Lesson learned - free is only free until it's not. > > So, I had never automated restoring the lot of backups in a directory. > Never needed to. However the Idera Free restore does that and I have > that working on the 2005 server so... all I need is a method of > reading the files in a directory. > > I go a googlin' and what pops up but Phil Factor. I LOVE Phil Factor > to begin with. Just a cool guy. Anyway within a few minutes I > discover a largeish piece of code that looks like it will work. > Except that it needs the OLEDB stuff turned on in surface area config. > Except that I've shut down all of the extraneous SQL Server services > (because this server normally just hosts my VMs). I finally get the > right service started, the OLEDB stuff enabled, turn off / on all the > services one last time and voila, TSQL code that hands me a recordset > of file names in a query. > > And on, and on, and on. With luck, before I go to bed tonight, I will > have restored my backups to the alternate server. > > I'm a wondering now... can I backup a database on server A running SQl > Server 2005 from Server B running 2008? I guess I'll find out. > > How to waste a day. > > Ahhhoooooommmmm this is what I do for a living... > Ahhhoooooommmmm this is what I do for a living... > Ahhhoooooommmmm this is what I do for a living... > > > -- > John W. Colby > www.ColbyConsulting.com > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com