[dba-SQLServer] File extensions

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