Sunday, March 11, 2012

detaching a db in sql 6

greeting ya all,
I was just wondering of how to detach a database in sqlserver 6? is
it the transerfer tool'
MTIA,
GrawshaNow, this was a whole ago, but...
That would be the DROP DATABASE command. SQL Server didn't actually removed
the disk devices in the
old architecture when you did DROP DATABASE (you created those devices expli
citly and a device can
be shared among several databases).
The hard part is to do "attach", which involves DISK REINIT and DISK REFIT,
something you really
only use for emergency recovery.
I suggest you save yourself *a lot* of trouble and do DUMP and LOAD (backup/
(restore). And even that
is a lot harder in the old architecture, so make sure you read up on the sub
ject if needed.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<grawsha2000@.yahoo.com> wrote in message
news:1170433784.946975.181760@.v45g2000cwv.googlegroups.com...
> greeting ya all,
> I was just wondering of how to detach a database in sqlserver 6? is
> it the transerfer tool'
> MTIA,
> Grawsha
>|||Add on to Tibor, In SQL 6.0 the best option to copy a database to one server
to another server will DUMP the database
and use LOAD Database in the destination server to Restore the database.
In SQL 6.0 there is no concept of files, all were devices and database will
reside above the devices.
Thanks
Hari
"grawsha2000@.yahoo.com" wrote:

> greeting ya all,
> I was just wondering of how to detach a database in sqlserver 6? is
> it the transerfer tool'
> MTIA,
> Grawsha
>

No comments:

Post a Comment