by Brian Vo » Tue, 17 Nov 1998 04:00:00
If anyone knows how I can move a database to a new drive, please let me know
Thanks
Brian Vos
by Steve Robinso » Tue, 24 Nov 1998 04:00:00
This depends how brave you are.
One way to do this is (If your brave)
backup your databases
take a copy of the .dat device to the new drive.
change the devices mapping (phyname) in sysdevices to point to the new
drive
restart sql server
or
(If your a little now careful)
backup the database
create a new database on the new device
load into the database again which will now reside on the new device
How brave are you feeling today !!!
Steve Robinson
SQLServer MVP
Quote:>I have run out of space on my primary drive on my server. I recently got a
>new drive and want to move the database on to this new drive completely. I
>thought of using NT Server disk tools to create a striped partition, but I
>can't because the drive the DB is on contains the NT server files.
>If anyone knows how I can move a database to a new drive, please let me
know
>Thanks
>Brian Vos
Dear all:
I have two Oracle instances reside on my NT server
One is for production, and one is for testing.
Now I would like to move my entire production database to my testing
database.
So I have done a full database export of my production database
But I realise that now when I do the full import to my testing database,
because the tesing database have a different instance name as the production
one, it will try to re-create all these objects in the production database
during the import.
What should I do to move all objects form my production database to the
testing database?
Thanks for all your help in advance!
2. How to replicate db within a LAN
3. ADO thinks DBMS is done, but DBMS ain't done
5. Trigger doing UNLOAD to file OR calling Store Procedure doing the UNLOAD to file
6. Tuning Question sort_mem vs pgsql_tmp
7. Caché from InterSystems - doing wh at other MV vendors should be doing
9. Moving 6.5 database to another 6.5 database with different character set
10. Moving databases sqlserver 7 databases between sites
11. Moving a database diagram to another database...
12. Moving a Access replicated database to a MSDE replicated database
13. Move data from one database to another database