Re: Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If it's an SQL server backup you can restore it to SQL Server. Renaming will not work. SQL Server allows you to read the content description from the bakup file as well. Renaming only works with file copies that just cot a ..BAK extention. Do not assume all bak files are just that.

Cheers


"David Parkes" <wibble@xxxxxxxxxx> wrote in message news:eFmSe72zHHA.484@xxxxxxxxxxxxxxxxxxxxxxx
Hi everyone,

We have a *.BAK file and inside it is some useful data. We do not know what program was used to produce this file all we know is it is a backup of an SQL database. Is there anyway we can extract the data which it contains without knowing the program used to create it?


.

Relevant Pages

  • Re: Enterprise Manager Wont Start
    ... As long as I dont rename it to its original name it will launch fine? ... this is a permissions issue then it is easily worked around by just renaming ... Not a lot of security here on permissions if that is all it takes ... > Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.server)
  • DETAILS SOUGHT: Renaming this user-defined function removes any existing permissions and extended p
    ... renaming a user defined function using ACC2002 front ... grants made in SQL Server survive the rename. ... However, as warned, extended properties are wiped. ...
    (microsoft.public.access.adp.sqlserver)
  • Update Fails for sysservers.
    ... After renaming my system, Sql Server name also changed. ... Profiler Title bar displays the old name. ...
    (microsoft.public.sqlserver.programming)
  • Re: sqlParameter DateTime problem - seconds ignored
    ... Oops, sorry, that's a problem in my example. ... I was renaming the parameters ... I create a data SQL Server data adapter with a parameter of DbType ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL STANDAR EDITION 7.0
    ... Looks in BOL and the following prior to renaming your server, ... > Can I rename a server after installing SQL Server DESKTOP EDITION 7.0? ...
    (microsoft.public.sqlserver.server)