Database tasks

Last modified: May 28, 2025

This section describes how to manage SQL Server databases using dbForge Studio. It covers key database lifecycle operations—including attaching and detaching databases, creating new databases, copying existing ones—and other essential database management tasks.

In this section

Attach a database

Detach a database

Create a database

Copy a database

Back up a database

Restore a SQL Server database

Generate database scripts

Create a scripts folder or a snapshot

Take a database online and offline

Analyze indexes

View index scan results

Export index scan results to a CSV file

Fix indexes

Analyze indexes from the command line

Want to find out more?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.

All features

All features

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

Request a demo

Request a demo

If you consider employing this tool for your business, request a demo to see it in action.

dbForge Studio for SQL Server logo

Ready to start using  

dbForge Studio for SQL Server?

Download a FREE 30-day trial