How to take backup - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

How to take backup

Author

Topic

sql2020
Yak Posting Veteran

54 Posts

Posted - 2010-11-09 : 06:11:21

Hi In this scenario how to take full backup

i have a database size of 1tb

here my disk

like D(700 gb),E(700gb),F(700gb)

how to take backup now. what are the steps follow.

sql2020

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-11-09 : 06:36:40

Is that free space or total space?

First things first, you need more disk space, or a backup compression tool. You should ideally have enough space for at least two full backups.

--
Gail Shaw
SQL Server MVP

sql2020
Yak Posting Veteran

54 Posts

Posted - 2010-11-09 : 06:43:57

Yes total free space but different drives.

How to take.could explain.

sql2020

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-11-09 : 07:13:23

Open up books Online, the section on database backup, it explains how to stripe a backup across multiple destinations.

I still think you need more disk space. You've barely got space for 2 full backup and no space for log backups.

--
Gail Shaw
SQL Server MVP

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-09 : 13:12:03

What edition and version of SQL Server are you using?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Kristen
Test

22859 Posts

Posted - 2010-11-10 : 02:36:53

"stripe a backup across multiple destinations"

Just curious: do folk routinely do this? Doesn't it make backup to (and restore from) tape a nightmare to administer and synchronise?

Or does striping improve WRITE performance of backups sufficiently that the tape management is "accommodated"?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-11-10 : 03:23:41

If the destinations are separate physical drives it can significantly improve performance. Good on VLDBs.

Personally I always do backups to disk, then disk to tape. In that case it's just that both locations have to go to tape

--
Gail Shaw
SQL Server MVP

Kristen
Test

22859 Posts

Posted - 2010-11-10 : 18:18:42

Thanks Gail

vaddesuresh
Starting Member

5 Posts

Posted - 2010-11-15 : 01:28:43

hi, you can take a full backup directly, if all data files are in same filegroup and follow regular fullbackup steps. If datafiles are in diferent filegroups then go for files and filegroup type full backup.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources