rajendran.e
Mr or Mrs. 500
Points: 531
More actions
April 29, 2009 at 3:28 am
#220680
I am planning to take database backup when the database is set to single user mode.Is there any problem while restoring the same backup file.
Paul Randal
One Orange Chip
Points: 29544
April 29, 2009 at 6:12 am
#985824
Nope - just be aware that when you restore it, the database will be in the same state as when you backed it up - i.e. it will be in single-user mode.
Paul RandalCEO, SQLskills.com: Check out SQLskills online training!Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandalSQL MVP, Microsoft RD, Contributing Editor of TechNet MagazineAuthor of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply