-
restoring differential backup
how to restore a diifferential backup
i take up an backup using command
prior i create an device using----->
exec Sp_adddumpdevice 'disk','[name]','c:\dump\dump1.bak'
then i take an backup using command---->
backup database [database_name] to [disk_name] with init,differential
now when i restore---->
restore database [database_name] from [name] with norecovery
restore database [database_name] from [name] with file=2
next when i take a differential backup a new file is created i.e file 3
so then to restore i have to use--->
restore database [database_name] from [name] with norecovery
restore database [database_name] from [name] with file=3
is there an way where this problem can be solved of keeping file track
can i always have an differential backup in one fixed defined file
so that i can restore directly from that file
how?
thanking
Mehul.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks