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 |
|
SQLError
Yak Posting Veteran
63 Posts |
 Posted - 2004-09-19 : 20:34:08
|
| I have read that it is very important.I have 1 database that I made. In it I don't have any storedprocedures. Just 2 data types I created.If I import this data base into a fresh install of sql server,wont I get my database, restored properly? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-19 : 20:42:15
|
| Yes.System db's contain thngs tat might be important to you though.e.g.Master contains logins.MSDB contains jobs and their history and server held dts packages.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
SQLError
Yak Posting Veteran
63 Posts |
Posted - 2004-09-19 : 21:38:45
|
| Well, I don't really care about logins or job histories,basically I just want the data in my database to be backed up,but I suppose it wont hurt to do a full backup of all the systemdatabases at the end of the day.thanks |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-19 : 22:54:37
|
| You should normally backup master and msdb as part of your normal backup routine.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-09-20 : 16:12:53
|
| If your going to backup the sys db's be sure you know how to restore them...Anyone have links to a good step by step on this?Surf On Dude! |
|
|
|
|
|
|
Importance of backing up system dbs