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 |
|
Rumak18
Starting Member
3 Posts |
 Posted - 2009-12-02 : 03:21:42
|
| Hallo,i`m quite new to SQL, so please be gentle (-:I have a SQL 2005 Express DB on a Win2k3 Server. There are several databases and the two icons "database snapshots" "system databases".Now i`m able to backup the databases separately, buch i wonder, if there is a possibility, to backup all the needed data in one file?Thanks for help. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-02 : 08:42:21
|
| no. each database gets it's own backup file |
 |
|
|
Rumak18
Starting Member
3 Posts |
Posted - 2009-12-02 : 14:27:16
|
| Ok, but what about the "database snapshots" and "system databases"? Do i have to back them up? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Rumak18
Starting Member
3 Posts |
Posted - 2009-12-03 : 03:35:26
|
| OK, so i don't need (Or isn't there just a possibility for this?) to backup the "database snapshots" and "system databases" field in SQL Management Studio? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-03 : 09:48:19
|
| backup master, msdb.backup model if you've changed it.don't backup tempdb.up to u on the db snapshots. depends on the purpose for having them. |
|
|
|
|
|
|
SQL - 2005EXP - Backup all Databases at once