September 24, 2000 05:24 PM

Restoring Databases

Rating: (0)
Michael D. Reilly
SQL Server Magazine
InstantDoc ID #9808
Last month's column, "Backup Strategies", looked at SQL Server's four backup options and covered how to choose the best option—or combination of options—for your SQL Server installation. This month, I cover how these backup strategies affect the restore process and your choice of recovery models.

Alt...

ARTICLE TOOLS

Want to use this article? Click here for options!

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Adowek, it may be a bit too late for you but I think you are trying to restore to a fat or fat 32 filesystem, which won't support file sizes larger than 2gb, reformat the disk to use NTFS, and the restore should be fine

Anonymous User 6/30/2005 5:11:33 PM

I am restoring a database that is over 4 GB. I have set that up via stored procedure to restore and then to add a user and set the attributes. The restore fails when the backup fike is over a 2 GB. THe MDF and LDF files are created but the database is not accessible. What could be causing this. If the backup file is less then 2 GB it rstores fine.

adowek 8/20/2004 10:01:14 AM

This article presents a very useful explanation for database restoring--I really like the explanation through scenarios.

Tamoor Ahmad OCP DBA 4/9/2002 4:29:54 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

advertisement

advertisement

GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

eBooks

Playbook for a Virtualized Datacenter | During challenging times, optimizing the IT infrastructure becomes imperative. Many organizations are looking to extend their virtualization efforts to encompass the entire datacenter. Get a step-through of your technology options and more.

White Papers

As the advances in USB devices have made them invaluable to most business users’, they have also exposed organizations to enormous risks. Learn how to easily enforce device/port control and data encryption policies without requiring new infrastructure and additional admin overhead.

WEB SEMINARS

Is Flexible Lockdown Possible? Join Darren Mar-Elia for this free web webinar exploring the various methods you should consider to protect and control your desktops while also understanding the impact on the end user community.
View Seminar On-Demand.

eLearning Series

Windows IT Pro brings the experts direct to you to share their real-world perspective, experience, and expertise. During each event, three sessions stream in real time, allowing you to learn, to ask questions, and to get solutions.
Upcoming event: SQL Server Consolidation

Subscribe to Windows IT Pro!

DevConnections ITTV Left-Brain SharePointPro Connections SQL Server Magazine SuperSite for Windows Windows IT Pro

© Penton Media, Inc.

Home About Us Advertise Customer Service Privacy Statement Subscribe/Renew Terms Of Use

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.