Help Crash!

Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
directory with all of the MDF and LDF files in it for the databases. Backups
directory was completely lost and as I understand it there are no outside
copies of backups. How if it is at all possible does one get these mounted
in such a way that they can be recovered in a new machine?Hi,
If you have all the Physical DAT files , including Master database . Then
all you have to do is..
1. Take a copy of all DAT files to a safe location
2. Install SQL 7 in the same folder as old installation
3. apply the same service pack as old
4. stop sql server and SQL Server Agent service
5. Copy all the DAT files to the same folder
6. Start SQl server and SQL Server Agent service.
Now your SQl server will be back as old.
Note:
Now onwards please prepare and backup strategy to backup your databases.
Thanks
Hari
MCDBA
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases.
Backups
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>|||Read about sp_attach_db and sp_attach_single_file_db in Books Online. These
are only guaranteed to work if you
properly detached the databases first. But if you are lucky...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message news:OcvkKvWeEHA.732@.tk2msftng
p13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases. Backu
ps
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>|||You can try using sp_attach_db, but if the database wasn't closed properly,
there is no guarantee.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases.
Backups
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>|||Copy the LDF and MDF files onto another computer with SQ Lon it and then run
sp_attach_db to attach each DB.
--
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases.
Backups
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>|||Will it have to be a SQL 7 installation since these came from SQL 7? Or will
it work with SQL 2000 as there are several machines with this installation,
but this may have been the last one remaining with SQL 7 on it
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
> Copy the LDF and MDF files onto another computer with SQ Lon it and then
run
> sp_attach_db to attach each DB.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Johannesburg, South Africa
> Mobile: +27-82-552-0268
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
> news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Backups
outside[vbcol=seagreen]
mounted[vbcol=seagreen]
>|||Hi,
You can also attach a sql 7 db to an sql 2000 server without data loss.
Bradley M. Small wrote:

> Will it have to be a SQL 7 installation since these came from SQL 7? Or wi
ll
> it work with SQL 2000 as there are several machines with this installation
,
> but this may have been the last one remaining with SQL 7 on it
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
>
> run
>
> outside
>
> mounted
>
>|||Hi,
You can also attach a sql 7 db to an sql 2000 server without data loss.
Bradley M. Small wrote:
> Will it have to be a SQL 7 installation since these came from SQL 7? Or wi
ll
> it work with SQL 2000 as there are several machines with this installation
,
> but this may have been the last one remaining with SQL 7 on it
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
>
> run
>
> outside
>
> mounted
>
>|||Hi,
You can also attach a sql 7 db to an sql 2000 server without data loss.
Bradley M. Small wrote:
> Will it have to be a SQL 7 installation since these came from SQL 7? Or wi
ll
> it work with SQL 2000 as there are several machines with this installation
,
> but this may have been the last one remaining with SQL 7 on it
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
>
> run
>
> outside
>
> mounted
>
>|||Hi,
You can also attach a sql 7 db to an sql 2000 server without data loss.
Bradley M. Small wrote:
> Will it have to be a SQL 7 installation since these came from SQL 7? Or wi
ll
> it work with SQL 2000 as there are several machines with this installation
,
> but this may have been the last one remaining with SQL 7 on it
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
>
> run
>
> outside
>
> mounted
>
>sql

Help Crash!

Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
directory with all of the MDF and LDF files in it for the databases. Backups
directory was completely lost and as I understand it there are no outside
copies of backups. How if it is at all possible does one get these mounted
in such a way that they can be recovered in a new machine?
Hi,
If you have all the Physical DAT files , including Master database . Then
all you have to do is..
1. Take a copy of all DAT files to a safe location
2. Install SQL 7 in the same folder as old installation
3. apply the same service pack as old
4. stop sql server and SQL Server Agent service
5. Copy all the DAT files to the same folder
6. Start SQl server and SQL Server Agent service.
Now your SQl server will be back as old.
Note:
Now onwards please prepare and backup strategy to backup your databases.
Thanks
Hari
MCDBA
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases.
Backups
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>
|||Read about sp_attach_db and sp_attach_single_file_db in Books Online. These are only guaranteed to work if you
properly detached the databases first. But if you are lucky...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases. Backups
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>
|||You can try using sp_attach_db, but if the database wasn't closed properly,
there is no guarantee.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases.
Backups
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>
|||Copy the LDF and MDF files onto another computer with SQ Lon it and then run
sp_attach_db to attach each DB.
--
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases.
Backups
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>
|||Will it have to be a SQL 7 installation since these came from SQL 7? Or will
it work with SQL 2000 as there are several machines with this installation,
but this may have been the last one remaining with SQL 7 on it
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
> Copy the LDF and MDF files onto another computer with SQ Lon it and then
run[vbcol=seagreen]
> sp_attach_db to attach each DB.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Johannesburg, South Africa
> Mobile: +27-82-552-0268
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
> news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Backups
outside[vbcol=seagreen]
mounted
>
|||Hi,
You can also attach a sql 7 db to an sql 2000 server without data loss.
Bradley M. Small wrote:

> Will it have to be a SQL 7 installation since these came from SQL 7? Or will
> it work with SQL 2000 as there are several machines with this installation,
> but this may have been the last one remaining with SQL 7 on it
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
>
> run
>
> outside
>
> mounted
>
>
|||Hi,
You can also attach a sql 7 db to an sql 2000 server without data loss.
Bradley M. Small wrote:
> Will it have to be a SQL 7 installation since these came from SQL 7? Or will
> it work with SQL 2000 as there are several machines with this installation,
> but this may have been the last one remaining with SQL 7 on it
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
>
> run
>
> outside
>
> mounted
>
>
|||Hi,
You can also attach a sql 7 db to an sql 2000 server without data loss.
Bradley M. Small wrote:
> Will it have to be a SQL 7 installation since these came from SQL 7? Or will
> it work with SQL 2000 as there are several machines with this installation,
> but this may have been the last one remaining with SQL 7 on it
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
>
> run
>
> outside
>
> mounted
>
>
|||Hi,
You can also attach a sql 7 db to an sql 2000 server without data loss.
Bradley M. Small wrote:
> Will it have to be a SQL 7 installation since these came from SQL 7? Or will
> it work with SQL 2000 as there are several machines with this installation,
> but this may have been the last one remaining with SQL 7 on it
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
>
> run
>
> outside
>
> mounted
>
>

Help Crash!

Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
directory with all of the MDF and LDF files in it for the databases. Backups
directory was completely lost and as I understand it there are no outside
copies of backups. How if it is at all possible does one get these mounted
in such a way that they can be recovered in a new machine?Hi,
If you have all the Physical DAT files , including Master database . Then
all you have to do is..
1. Take a copy of all DAT files to a safe location
2. Install SQL 7 in the same folder as old installation
3. apply the same service pack as old
4. stop sql server and SQL Server Agent service
5. Copy all the DAT files to the same folder
6. Start SQl server and SQL Server Agent service.
Now your SQl server will be back as old.
Note:
Now onwards please prepare and backup strategy to backup your databases.
Thanks
Hari
MCDBA
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases.
Backups
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>|||Read about sp_attach_db and sp_attach_single_file_db in Books Online. These are only guaranteed to work if you
properly detached the databases first. But if you are lucky...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases. Backups
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>|||You can try using sp_attach_db, but if the database wasn't closed properly,
there is no guarantee.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases.
Backups
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>|||Copy the LDF and MDF files onto another computer with SQ Lon it and then run
sp_attach_db to attach each DB.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases.
Backups
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>|||Will it have to be a SQL 7 installation since these came from SQL 7? Or will
it work with SQL 2000 as there are several machines with this installation,
but this may have been the last one remaining with SQL 7 on it :)
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
> Copy the LDF and MDF files onto another computer with SQ Lon it and then
run
> sp_attach_db to attach each DB.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Johannesburg, South Africa
> Mobile: +27-82-552-0268
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
> news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> > Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> > directory with all of the MDF and LDF files in it for the databases.
> Backups
> > directory was completely lost and as I understand it there are no
outside
> > copies of backups. How if it is at all possible does one get these
mounted
> > in such a way that they can be recovered in a new machine?
> >
> >
>|||Hi,
You can also attach a sql 7 db to an sql 2000 server without data loss.
Bradley M. Small wrote:
> Will it have to be a SQL 7 installation since these came from SQL 7? Or will
> it work with SQL 2000 as there are several machines with this installation,
> but this may have been the last one remaining with SQL 7 on it :)
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
>>Copy the LDF and MDF files onto another computer with SQ Lon it and then
> run
>>sp_attach_db to attach each DB.
>>--
>>--
>>Mike Epprecht, Microsoft SQL Server MVP
>>Johannesburg, South Africa
>>Mobile: +27-82-552-0268
>>IM: mike@.epprecht.net
>>MVP Program: http://www.microsoft.com/mvp
>>Blog: http://www.msmvps.com/epprecht/
>>"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
>>news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
>>Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
>>directory with all of the MDF and LDF files in it for the databases.
>>Backups
>>directory was completely lost and as I understand it there are no
> outside
>>copies of backups. How if it is at all possible does one get these
> mounted
>>in such a way that they can be recovered in a new machine?
>>
>>
>|||Hi,
You can also attach a sql 7 db to an sql 2000 server without data loss.
Bradley M. Small wrote:
> Will it have to be a SQL 7 installation since these came from SQL 7? Or will
> it work with SQL 2000 as there are several machines with this installation,
> but this may have been the last one remaining with SQL 7 on it :)
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
>>Copy the LDF and MDF files onto another computer with SQ Lon it and then
> run
>>sp_attach_db to attach each DB.
>>--
>>--
>>Mike Epprecht, Microsoft SQL Server MVP
>>Johannesburg, South Africa
>>Mobile: +27-82-552-0268
>>IM: mike@.epprecht.net
>>MVP Program: http://www.microsoft.com/mvp
>>Blog: http://www.msmvps.com/epprecht/
>>"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
>>news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
>>Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
>>directory with all of the MDF and LDF files in it for the databases.
>>Backups
>>directory was completely lost and as I understand it there are no
> outside
>>copies of backups. How if it is at all possible does one get these
> mounted
>>in such a way that they can be recovered in a new machine?
>>
>>
>|||Hi,
You can also attach a sql 7 db to an sql 2000 server without data loss.
Bradley M. Small wrote:
> Will it have to be a SQL 7 installation since these came from SQL 7? Or will
> it work with SQL 2000 as there are several machines with this installation,
> but this may have been the last one remaining with SQL 7 on it :)
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
>>Copy the LDF and MDF files onto another computer with SQ Lon it and then
> run
>>sp_attach_db to attach each DB.
>>--
>>--
>>Mike Epprecht, Microsoft SQL Server MVP
>>Johannesburg, South Africa
>>Mobile: +27-82-552-0268
>>IM: mike@.epprecht.net
>>MVP Program: http://www.microsoft.com/mvp
>>Blog: http://www.msmvps.com/epprecht/
>>"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
>>news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
>>Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
>>directory with all of the MDF and LDF files in it for the databases.
>>Backups
>>directory was completely lost and as I understand it there are no
> outside
>>copies of backups. How if it is at all possible does one get these
> mounted
>>in such a way that they can be recovered in a new machine?
>>
>>
>|||Hi,
You can also attach a sql 7 db to an sql 2000 server without data loss.
Bradley M. Small wrote:
> Will it have to be a SQL 7 installation since these came from SQL 7? Or will
> it work with SQL 2000 as there are several machines with this installation,
> but this may have been the last one remaining with SQL 7 on it :)
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
>>Copy the LDF and MDF files onto another computer with SQ Lon it and then
> run
>>sp_attach_db to attach each DB.
>>--
>>--
>>Mike Epprecht, Microsoft SQL Server MVP
>>Johannesburg, South Africa
>>Mobile: +27-82-552-0268
>>IM: mike@.epprecht.net
>>MVP Program: http://www.microsoft.com/mvp
>>Blog: http://www.msmvps.com/epprecht/
>>"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
>>news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
>>Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
>>directory with all of the MDF and LDF files in it for the databases.
>>Backups
>>directory was completely lost and as I understand it there are no
> outside
>>copies of backups. How if it is at all possible does one get these
> mounted
>>in such a way that they can be recovered in a new machine?
>>
>>
>|||Worked without a hitch! Thanks everyone.
"Martin Ha" <martin.ha@.gmx.net> wrote in message
news:410FB18D.10706@.gmx.net...
> Hi,
> You can also attach a sql 7 db to an sql 2000 server without data loss.
> Bradley M. Small wrote:
> > Will it have to be a SQL 7 installation since these came from SQL 7? Or
will
> > it work with SQL 2000 as there are several machines with this
installation,
> > but this may have been the last one remaining with SQL 7 on it :)
> >
> >
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> > news:%23IPG20WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
> >
> >>Copy the LDF and MDF files onto another computer with SQ Lon it and then
> >
> > run
> >
> >>sp_attach_db to attach each DB.
> >>
> >>--
> >>--
> >>Mike Epprecht, Microsoft SQL Server MVP
> >>Johannesburg, South Africa
> >>Mobile: +27-82-552-0268
> >>IM: mike@.epprecht.net
> >>
> >>MVP Program: http://www.microsoft.com/mvp
> >>
> >>Blog: http://www.msmvps.com/epprecht/
> >>
> >>"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> wrote in message
> >>news:OcvkKvWeEHA.732@.tk2msftngp13.phx.gbl...
> >>
> >>Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> >>directory with all of the MDF and LDF files in it for the databases.
> >>
> >>Backups
> >>
> >>directory was completely lost and as I understand it there are no
> >
> > outside
> >
> >>copies of backups. How if it is at all possible does one get these
> >
> > mounted
> >
> >>in such a way that they can be recovered in a new machine?
> >>
> >>
> >>
> >>
> >
> >

Help configuring database to work as intended

Hello everyone, I have created my web application in VS 2005 using asp.net 2.0 and the built in sql .mdf database creater that comes with visual studio. After I developed my website, I then wanted to move it to one of our servers on the network, which I did without a problem. The website works fine but here is my challange. I need users to be able to connect to the database via login script and the script inserts computer data into the database. So I figured I need to attach the Database to SQL Server 2005. When I try to do this it gives me this database is in use. So I stop the website in IIS, and it allows me to add the database into the SQL Server. Once I do this, and start the website again, the website no longer works and I get a bunch of database errors, that do not get fixed untill I re-copy the website to the server.

Is there a way to just connect to a .mdf file on the network that is not attached to a sql server, through a connection string in a login script? Maybe there is something else I need to do to the database before copying to the server? Or should I re-programm the website with a newly created database in SQL Server, and use that as the datasource?

There is no need to stop the webserver to copy or attach the database. to attach the database bring the particular database to offline and copy the mdf and ldf as per u r required location.

Thank u

Baba

Please remember to click "Mark as Answer" on this post if it helped you.

|||

Ok but then why, when I attach the database to a SQL Server, and try to run the website again, it no longer works? It gives me a bunch of database errors that basiaclly come down to, the database is already open.

|||

Hi,

using asp.net 2.0 and the built in sql .mdf datab

From your description, it seems that you want to move the mdf file in SQLExpress to SQLServer2005, right?

If so, I suggest that you can use aspnet_regsql tool to achieve that. The ASP.NET SQL Server Registration tool is used to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET, or to add or remove options from an existing database. The Aspnet_regsql.exe file is located in the [drive:]\%windir%\Microsoft.NET\Framework\version folder on your Web server.

You can give the option '-d' to specify the name of the database to create or modify for use with application services. If the database is not specified, the default database name of "aspnetdb" is used.

For details, see:http://msdn2.microsoft.com/en-us/library/ms229862(VS.80).aspx

Thanks.

sql

Help - recover deleted .MDF file

Hello,
By mistake I deleted database file from hard disk. Is there any way I can
recover the file please?
Thanks,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/Is it in the Recycle bin?
Do you have a backup?
Other than that, if nothing has reused any of its sectors, I think there are
untilities that can recover it, but I'm not sure which ones they are.
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:BD8F810F-F5E3-4590-9CCB-3D102C4775F5@.microsoft.com...
> Hello,
> By mistake I deleted database file from hard disk. Is there any way I can
> recover the file please?
> Thanks,
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/

HELP - problem after copying MDF and Log files

I had a problem where a log file was deleted. I managed to get the database
recovered on my own machine. I sent the MDF and Log files to the client so
he could stop SQL Server, copy the files and then start SQL Server again.
Now I can't get into SQL Server at all - it keeps telling me SQL Server does
not exist or access denied. I tried to delete the files that I copied (after
shutting down SQL Server) but it didn't work - on startup I still can't
access the SQL Server with any of the client tools. HELP!Which database was the log lost for? As long as it was not master or model
you may be able to use sp_attach_single_file_db.
Check if SQL Server is running.
If you did it to master or model, you have messed up the server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"claire" <claire@.discussions.microsoft.com> wrote in message
news:AE9EC5D3-724A-4480-8367-D85855839152@.microsoft.com...
> I had a problem where a log file was deleted. I managed to get the
database
> recovered on my own machine. I sent the MDF and Log files to the client
so
> he could stop SQL Server, copy the files and then start SQL Server again.
> Now I can't get into SQL Server at all - it keeps telling me SQL Server
does
> not exist or access denied. I tried to delete the files that I copied
(after
> shutting down SQL Server) but it didn't work - on startup I still can't
> access the SQL Server with any of the client tools. HELP!
>|||Stopping the server, copying the files then starting was probably not a good
idea.
If you had the database on your machine then sending a backup and gettig the
client to restore would have been a better option.
Check the sql server logs and application logs - you will probably see a
message to say what has happenned. It sounds like he has corrupted master,
model or done something to change the path of the system databases.
This is probably recoverable but you might be better off re-installing sql
server and attaching all the databases (try ttaching on another server first
to check integrity).
You then might want to look at your backup strategy in case this happens
again.

HELP - problem after copying MDF and Log files

I had a problem where a log file was deleted. I managed to get the database
recovered on my own machine. I sent the MDF and Log files to the client so
he could stop SQL Server, copy the files and then start SQL Server again.
Now I can't get into SQL Server at all - it keeps telling me SQL Server does
not exist or access denied. I tried to delete the files that I copied (after
shutting down SQL Server) but it didn't work - on startup I still can't
access the SQL Server with any of the client tools. HELP!
Which database was the log lost for? As long as it was not master or model
you may be able to use sp_attach_single_file_db.
Check if SQL Server is running.
If you did it to master or model, you have messed up the server.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"claire" <claire@.discussions.microsoft.com> wrote in message
news:AE9EC5D3-724A-4480-8367-D85855839152@.microsoft.com...
> I had a problem where a log file was deleted. I managed to get the
database
> recovered on my own machine. I sent the MDF and Log files to the client
so
> he could stop SQL Server, copy the files and then start SQL Server again.
> Now I can't get into SQL Server at all - it keeps telling me SQL Server
does
> not exist or access denied. I tried to delete the files that I copied
(after
> shutting down SQL Server) but it didn't work - on startup I still can't
> access the SQL Server with any of the client tools. HELP!
>
|||Stopping the server, copying the files then starting was probably not a good
idea.
If you had the database on your machine then sending a backup and gettig the
client to restore would have been a better option.
Check the sql server logs and application logs - you will probably see a
message to say what has happenned. It sounds like he has corrupted master,
model or done something to change the path of the system databases.
This is probably recoverable but you might be better off re-installing sql
server and attaching all the databases (try ttaching on another server first
to check integrity).
You then might want to look at your backup strategy in case this happens
again.

HELP - problem after copying MDF and Log files

I had a problem where a log file was deleted. I managed to get the databas
e
recovered on my own machine. I sent the MDF and Log files to the client so
he could stop SQL Server, copy the files and then start SQL Server again.
Now I can't get into SQL Server at all - it keeps telling me SQL Server doe
s
not exist or access denied. I tried to delete the files that I copied (afte
r
shutting down SQL Server) but it didn't work - on startup I still can't
access the SQL Server with any of the client tools. HELP!Which database was the log lost for? As long as it was not master or model
you may be able to use sp_attach_single_file_db.
Check if SQL Server is running.
If you did it to master or model, you have messed up the server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"claire" <claire@.discussions.microsoft.com> wrote in message
news:AE9EC5D3-724A-4480-8367-D85855839152@.microsoft.com...
> I had a problem where a log file was deleted. I managed to get the
database
> recovered on my own machine. I sent the MDF and Log files to the client
so
> he could stop SQL Server, copy the files and then start SQL Server again.
> Now I can't get into SQL Server at all - it keeps telling me SQL Server
does
> not exist or access denied. I tried to delete the files that I copied
(after
> shutting down SQL Server) but it didn't work - on startup I still can't
> access the SQL Server with any of the client tools. HELP!
>|||Stopping the server, copying the files then starting was probably not a good
idea.
If you had the database on your machine then sending a backup and gettig the
client to restore would have been a better option.
Check the sql server logs and application logs - you will probably see a
message to say what has happenned. It sounds like he has corrupted master,
model or done something to change the path of the system databases.
This is probably recoverable but you might be better off re-installing sql
server and attaching all the databases (try ttaching on another server first
to check integrity).
You then might want to look at your backup strategy in case this happens
again.

hellp with the sql is needed

hello i am a beginner:

on the .mdf sql.s 2005Ex

i need to present:

the 12 month as field name

whan the first filed is the customer name

and the rest is the sum(sale)

so the result will be like this

name 1 2 3 4 5 6 7 8 9 10 11 12

name1 $1 $2 0$ 8$ $1 $2 0$ 8$ $1 $2 0$ 8$

name2 $1 $2 0$ 8$ $1 $23 0$ 8$ $1 $23 0$ 8$

name3 $1 $2 0$ 8$ $1 $2 0$ 8$ $13 $2 0$ 8$

name4 $1 $2 0$ 83$ $1 $2 0$ 8$ $1 $2 0$ 8$

well so far i reached this - wich do the sum but on 12 row per name: well .. so if you could help me ?

SELECT
CASE WHEN MONTHs = 1 THEN MONEY ELSE 0 END AS '1',
CASE WHEN MONTHs = 2 THEN MONEY ELSE 0 END AS '2',
CASE WHEN MONTHs = 3 THEN MONEY ELSE 0 END AS '3',
CASE WHEN MONTHs = 4 THEN MONEY ELSE 0 END AS '4',
CASE WHEN MONTHs = 5 THEN MONEY ELSE 0 END AS '5',
CASE WHEN MONTHs = 6 THEN MONEY ELSE 0 END AS '6',
CASE WHEN MONTHs = 7 THEN MONEY ELSE 0 END AS '7',
CASE WHEN MONTHs = 8 THEN MONEY ELSE 0 END AS '8',
CASE WHEN MONTHs = 9 THEN MONEY ELSE 0 END AS '9',
CASE WHEN MONTHs = 10 THEN MONEY ELSE 0 END AS '10'

FROM

(SELECT DISTINCT MONTH(tblActoin.MyDate) AS MONTHs, SUM(tblActoin.amount) AS MONEY, tblIdentity.name
FROM tblActoin INNER JOIN
tblIdentity ON tblActoin.IdentityID = tblIdentity.id
GROUP BY tblActoin.MyDate, tblIdentity.name) AS derivedtbl_1

thanks

try this

SELECT Names,
sum(CASE WHEN MONTHs = 1 THEN MONEY ELSE 0 END) AS '1',
sum(CASE WHEN MONTHs = 2 THEN MONEY ELSE 0 END) AS '2',
sum(CASE WHEN MONTHs = 3 THEN MONEY ELSE 0 END) AS '3',
sum(CASE WHEN MONTHs = 4 THEN MONEY ELSE 0 END) AS '4',
sum(CASE WHEN MONTHs = 5 THEN MONEY ELSE 0 END) AS '5',
sum(CASE WHEN MONTHs = 6 THEN MONEY ELSE 0 END) AS '6',
sum(CASE WHEN MONTHs = 7 THEN MONEY ELSE 0 END) AS '7',
sum(CASE WHEN MONTHs = 8 THEN MONEY ELSE 0 END) AS '8',
sum(CASE WHEN MONTHs = 9 THEN MONEY ELSE 0 END) AS '9',
sum(CASE WHEN MONTHs = 10 THEN MONEY ELSE 0 END) AS '10,
sum(CASE WHEN MONTHs = 11 THEN MONEY ELSE 0 END) AS '11',
sum(CASE WHEN MONTHs = 12 THEN MONEY ELSE 0 END) AS '12'

FROM

(SELECT DISTINCT MONTH(tblActoin.MyDate) AS MONTHs, SUM(tblActoin.amount) AS MONEY, tblIdentity.name as Names
FROM tblActoin INNER JOIN
tblIdentity ON tblActoin.IdentityID = tblIdentity.id
GROUP BY tblActoin.MyDate, tblIdentity.name) AS derivedtbl_1)

group by Names

|||Yes!!! Thank you!!!