MartyConnelly
martyconnelly at shaw.ca
Tue Sep 14 11:15:26 CDT 2004
Here is a freebie replacement for EM (not completely compatible missing some options) for SQL 7 and 2000 (2 different versions) comes with VB6 source code, works through SQL DMO http://www.asql.biz/DbaMgr.shtm I believe BMC used to have a free Web Version of EM. Andy Lacey wrote: >Thanks Michael. Taking it home may not be on. Whilst I have SQL server >theyy, as far as I know, just have a 3rd-party app that (I think) uses SQL >server as a BE. So they probabaly don't have EM or any tools. Would that be >right? If someone supplies a product using a SQL Server BE I'm assuming they >don't supply much more than the database and drivers. >-- >Andy Lacey >http://www.minstersystems.co.uk > > > >--------- Original Message -------- >From: dba-sqlserver at databaseadvisors.com >To: dba-sqlserver at databaseadvisors.com <dba-sqlserver at databaseadvisors.com> >Subject: RE: [dba-SQLServer] File extensions >Date: 14/09/04 10:23 > > > >>Andy, >> >>I'm pretty sure with sql you can give it any extension. However the >>defaults are mdf for the data and ldf for the log file. >> >>As to taking the files home... well maybe, maybe not ;-) >>You will need to hook up an interface of some kind to see what what with >>SQL. (You probably can do it from cmd line but I'm not sure) >>You need Enterprise Manager(EM) or some other tool, there are free ones >>out there but I don't have a link. >>>From EM I would backup the db (may be more then 1 data file), take the >>backup home, restore it with EM. >>If the db is over 2gb you will need the full SQL server, if less then >>MSDE should be OK. >> >>hope that's enough to get you started? >> >>cheers >> >>Michael M >> >>Sent this hours ago but hasn't appeared, hence trying again - so >>apologies in advance when the original turns up. >> >>Hello good people on this wet and windy Autumn evening in the UK >> >>Simple question from a simple soul. I keep a weather eye on the SQL >>server list but never having actually developed a SQL system my question >>is: if I go to look at a client's existing system how can I tell if it >>is SQL (which I think it is)? Would file suffixes tell me, or can a >>developer call a database anything he/she likes? And if the file >>suffixes are the answer what are the magic three letters? Going on from >>there, if I was offered the opportunity to take the data away to have a >>look at it can I just zip up a file or two, and if so what would I need >>in order to be able to read the data in Access when I got back home? >> >>-- Andy Lacey >>http://www.minstersystems.co.uk >> >>_______________________________________________ >>dba-SQLServer mailing list >>dba-SQLServer at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >>http://www.databaseadvisors.com >> >>_______________________________________________ >>dba-SQLServer mailing list >>dba-SQLServer at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >>http://www.databaseadvisors.com >> >> >> >> >> >> >> >> > >________________________________________________ >Message sent using UebiMiau 2.7.2 > >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com > > > > -- Marty Connelly Victoria, B.C. Canada