Member Avatar for jacksantho

I want to take backup of my server database at my local machine........ how can i do this......

Thanks in advance

  • 2 Contributors
  • 3 Replies
  • 106 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by pritaeas

Dani AI

Generated

Short answer (clarifying ): make a normal SQL Server backup (.bak) on the server, then bring that .bak to your PC — or have SQL Server write the .bak directly to a shared folder on your PC. The backup operation runs inside the SQL Server service on the server, so file paths and permissions are resolved by the server, not by your SSMS client.

Typical workflows and gotchas:

  1. Backup on the server, then copy to local

  • In SSMS: connect to the server, right‑click the database -> Tasks -> Back Up -> choose Full -> Destination -> add a server path (for example C:\Backups\MyDB.bak) -> OK.

  • Copy the resulting .bak to your PC (Windows share, RDP file copy, SCP, FTP, Robocopy, etc.).

  • Example T‑SQL to create and then verify a backup:

    BACKUP DATABASE [MyDB]
TO DISK = N'C:\Backups\MyDB.bak'
WITH INIT, CHECKSUM, STATS = 10;

RESTORE VERIFYONLY FROM DISK = N'C:\Backups\MyDB.bak';
  1. Backup directly to your PC (UNC share)

  • Share a folder on your PC (e.g. \\YourPC\SQLBackups) and grant write access to the account that SQL Server uses.

  • Use that UNC path as the backup destination in SSMS or T‑SQL:

    BACKUP DATABASE [MyDB]
TO DISK = N'\\YourPC\SQLBackups\MyDB.bak'
WITH INIT, CHECKSUM, STATS = 10;

Permission notes and troubleshooting

  • If you get "access denied", SQL Server’s service account likely lacks network rights. Mapped drive letters are not visible to services — use UNC paths. Run SQL Server under a domain account or grant the machine account the share permission if appropriate.
  • Never copy .mdf/.ldf files while the instance is running; use BACKUP or stop the service.
  • For large DBs use WITH COMPRESSION (if supported) and always RESTORE VERIFYONLY after copying.

Microsoft documentation on backing up and the BACKUP command is available from Microsoft for detailed options and examples: .

Recommended Answers

All 3 Replies

Member Avatar for pritaeas

Create a backup in the server manager, copy the file, restore it at home.

Member Avatar for jacksantho

I don't know. Can you give me some clear explanations. Thanks in advance

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.