Andy Lacey
andy at minstersystems.co.uk
Tue Sep 14 12:25:00 CDT 2004
Thanks to all for your help. -- Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: dba-sqlserver-bounces at databaseadvisors.com > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf > Of Francisco Tapia > Sent: 14 September 2004 18:08 > To: dba-sqlserver at databaseadvisors.com > Subject: Re: [dba-SQLServer] File extensions > > > Additionally Andy, you can now buy Sql Server Developer for > $50 from M$ and you'll be able to load databases larger than > the 2gb limit. plus have more control over the environment > along w/ that you get EM and QA and all the other utilities > that come w/ Sql Server. > > > On Tue, 14 Sep 2004 09:15:26 -0700, MartyConnelly > <martyconnelly at shaw.ca> wrote: > > 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 > > > > > > > > > > _______________________________________________ > > dba-SQLServer mailing list > > dba-SQLServer at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > http://www.databaseadvisors.com > > > > > > > > -- > -Francisco > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > >