Solved

Shrink sybase database

Posted on 2009-04-07
2
1,802 Views
Last Modified: 2012-05-06
How to shrink sybase database. and its device size?
0
Comment
Question by:sar1479
2 Comments
 
LVL 14

Accepted Solution

by:
Jan_Franek earned 500 total points
ID: 24086057
0
 
LVL 10

Expert Comment

by:bret
ID: 24087973
Once the database has been shrunk, you can reduce the device sizes by:

dump database
sp_dropdevice
disk init new device with smaller size
create database for load
load database
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Copy a TadoDataSet to another and apply changes to database. 11 1,234
Sybase - sp_cacheconfig 1 947
InterSystems Caché OPEN QUERY 4 416
sybase 3 26
Is your company's data protection keeping pace with virtualization? Here are 7 dynamic ways to adapt to rapid breakthroughs in technology.
We have come a long way with backup and data protection — from backing up to floppies, external drives, CDs, Blu-ray, flash drives, SSD drives, and now to the cloud.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now