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.
| Author |
Topic |
|
bananafishbone
Starting Member
7 Posts |
 Posted - 2005-08-23 : 08:06:18
|
| Is it possible to restore to a clean instance of SQL server, from a full backup, without knowing to contents of the backup? i.e. Do I have to create blank databases and tables to enable me to restore?My SQL server instance has about 20 individual databases. I create a full backup on a weekly basis, a diff backup every day and a trans log backup every 4 hrs. I haven't yet verified that I can recover from these backups (gulp!). My full backup has grown to around 4.8GB, is it better to create backups of individual databases rather than the whole instance?I intend to install SQL on a spare server then retore the backups to that. Thanks for any help in advance.Colin. |
|
|
bananafishbone
Starting Member
7 Posts |
Posted - 2005-08-23 : 08:25:11
|
| Not sure if I'm making sense.........In the event of a disaster, if all I have is a copy of the server_FULL.bak file, can I restore this to a new SQL Server?Ta |
 |
|
|
|
|
|
General Backup / Restore Question