🔧 How to Create a Database in Sybase (Including Devices)

 

If you're used to working with Microsoft SQL Server, creating a database in Sybase ASE (Adaptive Server Enterprise) can feel quite different. One of the key distinctions is that Sybase requires you to explicitly create devices before you can create a database.

This guide walks you through the full process: from creating devices to creating the database and setting the correct owner.

 

🧱 What Are Devices in Sybase?

In Sybase ASE:

  • A device is a physical file (or raw partition) where data is stored.

  • You typically separate your data device (for tables, indexes, etc.) and log device (for transactions).

  • This allows for better performance and recovery management.

📂 Step 1: Create the Devices

You must first create the data and log devices using disk init.

 -- Create a data device (e.g., 100 MB)
disk init
  name = "datadev1",
  physname = "/sybase/data/datadev1.dat",
  size = 51200

-- Create a log device (e.g., 50 MB)
disk init
  name = "logdev1",
  physname = "/sybase/data/logdev1.dat",
  size = 25600

-- Optionally, add another data device for later growth
disk init
  name = "datadev2",
  physname = "/sybase/data/datadev2.dat",
  size = 70000

⚠️ Note: Adjust the file paths and sizes according to your server setup.

🗃️ Step 2: Create the Database

Now that your devices are ready, create the database and allocate space.

 USE master
GO

-- Initial database creation
CREATE DATABASE mydatabase
ON datadev1 = 1000
LOG ON logdev1 = 250
GO

-- Extend the database on a second data device
ALTER DATABASE mydatabase
ON datadev2 = 1000
GO

-- Add more space as needed
ALTER DATABASE mydatabase
ON datadev2 = 348
GO

💡 The numbers (e.g., 1000) represent the number of 2KB pages.
1000 pages = ~2MB. So adjust based on how much space you need.

👤 Step 3: Set the Database Owner

It's a good practice to set the database owner to sa to ensure full permissions — especially for automation jobs or admin tasks.

USE mydatabase
GO
EXEC sp_changedbowner 'sa'
GO

✅ Summary

  • ✅ Create devices with disk init

  • ✅ Create the database using CREATE DATABASE ... ON ... LOG ON ...

  • ✅ Extend the database with ALTER DATABASE

  • ✅ Set the owner to sa with sp_changedbowner


Comments

Post a Comment

Popular posts from this blog

Free Monthly Budget Spreadsheet (UK-Friendly)

Want to take control of your finances and live more frugally? I've created a simple, easy-to-use monthly budget spreadsheet — perfect for UK households. Track your income, bills, spending, savings, and more in one place. 📊 What’s Included: Income and bills tracker Subscriptions and everyday expenses Savings and debts planner Savings goals section — plan and visualise your future funds £1 to £365 Savings Challenge — stay motivated as you save! 💡 What is the £1 to £365 Savings Challenge? This challenge helps you gradually save £665 in a year. You simply save an amount between £1 and £365 — one of each — and tick them off as you go. You can save the biggest amounts first, smallest first, or mix it up depending on your budget that week. It’s a flexible and fun way to build savings! 📌 Sample Data & Formulas Each sheet includes sample data to show how to use it. Please delete or replace only the numbers — not the formulas. Any field with calculation...
Read more
Image
👨‍💻 Helping Kai Build His First Front-End App It’s been a few weeks since my last post with Kai. We’ve been heads-down coding together, and instead of just talking about database security, we started building a working front end for his application. This has been a big step for Kai — going from SQL tables and stored procedures to actually seeing his app come alive in the browser. We used C# with ASP.NET Web Forms (ASPX) to create login and home pages, and then expanded into pages for courses, students, lectures, grades, and even a small library system.     🔑 Step 1: Building the Login Page Before you can get into the app, you need a secure login. We reused our earlier hashed + salted password system but wrapped it with an ASPX login form. <asp:TextBox ID="txtUsername" runat="server" Placeholder="Username"></asp:TextBox> <asp:TextBox ID="txtPassword" runat="server" TextMode="Password" Placeholder=...
Read more

Financial Literacy and ADHD – Money, Mistakes, and Learning the Hard Way

Let’s talk money. Not the flashy kind with yachts and investment portfolios. I mean the real stuff—bills, debt, impulse buys, budgeting apps, and that sinking feeling when your card gets declined at Tesco. I grew up without much. Council estate life doesn’t come with lessons in financial planning. You learn fast—or you don’t eat. But ADHD made learning about money even harder. It’s not just about being “bad with money.” ADHD affects how we make decisions, process consequences, and handle stress. Here’s what ADHD and money looks like for me: I once gave away my phone to someone who needed it… and forgot to cancel the bill. It cost me thousands . I’ve bought gadgets on a whim, convinced they’d change my life, only for them to gather dust. I’ve missed payments, not because I didn’t have the money—but because I forgot the due date. I’ve signed up to trials and subscriptions I forgot to cancel. I’ve had months where I lived like a millionaire, followed by months where I ...
Read more