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 |
|
marconi8
Yak Posting Veteran
73 Posts |
 Posted - 2003-05-03 : 12:42:57
|
| working with interbase i was able to make only metadata backup,how to make only metadata backup in mssql ? |
|
|
marconi8
Yak Posting Veteran
73 Posts |
Posted - 2003-05-03 : 12:43:48
|
| for backup and restore at this moment i'am using this structure1) BACKUP DATABASE TEST_1 TO TEST_BACKUP2) DROP DATABASE TEST_13) RESTORE DATABASE TEST_1 FROM TEST_BACKUP |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-05-03 : 12:48:43
|
| You can use Enterprise Manager to Generate SQL Scripts for all (or selected) objects in the tables. It will generate the SQL commands to create all of those objects, and you can simply run the SQL script whenever you need to recreate the database. |
|
|
|
marconi8
Yak Posting Veteran
73 Posts |
Posted - 2003-05-03 : 13:50:38
|
| i have readed more about backup and restore, but i have still a small basic question...if my db will be backuped and restored during users insert delete or update , all will be normal or not ? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-05-03 : 14:15:09
|
| Books Online will give you more details if you look under "BACKUP" and its related links, but yes, users can continue to perform regular operations during a backup, but not a restore. All UPDATE, DELETE, and normal INSERT operations are logged in the transaction log. Bulk insert operations may or may not be logged as well, but they will still be stored in the database regardless. |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-05-04 : 08:24:54
|
| There is already a handly program that comes with SQL Server that you can schedule to generate scripts - it's called scptxfr.exe and is found in the upgradre folder. Pass it the /? switch for syntax. As to db/log backups - log backups are consistent to the point the log backup STARTS, db backups are consistent to the point the db backup FINISHES. During a restore operation the database is not accessible until both REDO and UNDO operations have finished.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-04 : 11:19:59
|
| Awesome, JAn article with examples would be good for the masses.It's unlikely that if you don't read this post it will ever be seen again and the same question will asked over and over.It would be nice if it include all the secret .exe'sI just tryind dbcheck with DUMPSCHEMA and it looks like it ran but my output file was blank. It would be nice to have some examples of what these exe's do.ThanksEdited by - ValterBorges on 05/04/2003 11:28:39Edited by - ValterBorges on 05/04/2003 11:45:38 |
|
|
|
|
|
|
|
|
BACKUP RESTORE, only metadata ?