[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