I had some problems with my SQL-program and had to re-install the program. Is it possible to copy the datamap back into th sql directory and use this data or is this only possible with a restore'
Regards,
MarcWhat's a 'datamap'?
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"fedum" <anonymous@.discussions.microsoft.com> wrote in message
news:82B772DB-A543-4A29-8872-9FB759118ADF@.microsoft.com...
> I had some problems with my SQL-program and had to re-install the program.
Is it possible to copy the datamap back into th sql directory and use this
data or is this only possible with a restore?
> Regards,
> Marc|||Perhaps fedum is referring to the mdf, ldf and ndf files? If so, fedum, check out sp_attach_db.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:%23vxpAP2sDHA.2408@.tk2msftngp13.phx.gbl...
> What's a 'datamap'?
>
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "fedum" <anonymous@.discussions.microsoft.com> wrote in message
> news:82B772DB-A543-4A29-8872-9FB759118ADF@.microsoft.com...
> > I had some problems with my SQL-program and had to re-install the program.
> Is it possible to copy the datamap back into th sql directory and use this
> data or is this only possible with a restore?
> > Regards,
> > Marc
>|||well I mean the directory under the MSSQL7 directory where sql stores his data. Because I have now resent backup from my data and therefore I would like to try if I could copy this data back under this directory
Regards
Marc|||See my post from yesterday.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"fedum" <anonymous@.discussions.microsoft.com> wrote in message
news:EDC83C7C-E88B-4313-9F4F-0C6B1306E6CD@.microsoft.com...
> well I mean the directory under the MSSQL7 directory where sql stores his data. Because I have now
resent backup from my data and therefore I would like to try if I could copy this data back under
this directory.
> Regards,
> Marc|||Thanks
But when I read the comment about sp_attach_db then it is allways combined with sp_detach_db. The problem is that the database is not detached before becouse of the problems withh SQL. Can I allso use the attach without detach' Can you please inform
Marc|||Sometimes sp_attach_db will work even if you didn't detach it first, sometimes it doesn't. Give it a
try!
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"fedum" <anonymous@.discussions.microsoft.com> wrote in message
news:90CF0F46-34BA-4881-9A6E-23E1E3233730@.microsoft.com...
> Thanks,
> But when I read the comment about sp_attach_db then it is allways combined with sp_detach_db. The
problem is that the database is not detached before becouse of the problems withh SQL. Can I allso
use the attach without detach' Can you please inform?
> Marc
