The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

We currently have a large V9 database (replicating) which we need to upgrade to V16 - The disk on the server is running very low and i would like to move it to a external USB drive attached to the server. The file locations ar

C:\SDATA_LOG - This is holding the log files E:\SDATA - This holds the main DB file (100GB)

Usually I would use dbunload -ar (Directory) - but as this creates a copy I would run out of disk space.

If I copy the main DB onto the external disk (F:) can I still run this command ? (leaving the log files on the C: dive) ? -If so do I just then copy the upgraded file back to the E:\SDATA directory ?

Thanks

Mark

asked 10 Apr '15, 12:47

ThelmaCottage's gravatar image

ThelmaCottage
2611
accept rate: 0%


If you move the v9 database to your external disk then I'd suggest that you use "dbunload -an newfile.db ..." to create a new v16 database on your C: disk. This has two advantages: (1) you will have a backup of your original v9 database, and (2) you do not need to move/copy the new database back to your c: drive when it is done.

HTH

permanent link

answered 10 Apr '15, 13:20

Mark%20Culp's gravatar image

Mark Culp
22.3k9129262
accept rate: 40%

Thanks for the comments. The C: drive also very limited space. I would like to keep the main db file on a separate volume to the log files as well.

Would my suggestion above work ? It's not a problem copying files back and forth.

(10 Apr '15, 13:33) ThelmaCottage
Replies hidden
2

I guess my main point is that there is really no advantage to using -ar instead of -an because -ar simply does -an (under the covers with a temporary database name) and then does a rename when it is done.... hence during the rebuild there must be enough space for both the old (v9) and new (v16) database. Go ahead and use -ar if you wish but I'd recommend always that you have a full backup of your database before using -ar just in case something goes wrong!

(10 Apr '15, 13:36) Mark Culp

@Mark: Just as a side note: Does an external drive qualify as a fully-supported storage device? - I'm refering to that exhortation from the "The transaction log" docs page:

The database file and the transaction log file must be located on the same physical computer as the database server or accessed via a SAN or iSCSI configuration. Database files and transaction log files located on a remote network directory can lead to poor performance, data corruption, and server instability.

FWIW, the link following that quote still points to a Sybase URL which is not accessible anymore...

(13 Apr '15, 03:19) Volker Barth

@Volker: Wouldn't use this external drive in normal production - it's just a way to get over the problem of limited space on the main volume.

(13 Apr '15, 04:37) ThelmaCottage
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×51
×37
×37
×30
×7

question asked: 10 Apr '15, 12:47

question was seen: 267 times

last updated: 13 Apr '15, 04:37