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 |
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
 Posted - 2006-11-28 : 07:26:01
|
| hi,whats the best way for me to back up an instance within my sql server 2005?(all databases within instance)thanx |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-28 : 08:01:14
|
Whole instance backup isn't possible.you can backup all databases.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2006-11-28 : 16:00:20
|
| so if i wanted to create a maintanance plan for one of the instances the best thing would be to perform a full back up of the database? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-28 : 17:08:52
|
| yesGo with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-29 : 09:02:57
|
| "the best thing would be to perform a full back up of the database?"i.e. of all the databases ...Kristen |
|
|
|
|
|
|
back up