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 |
|
books1999
Starting Member
1 Post |
 Posted - 2004-06-24 : 10:50:08
|
| Hi,I have a database that I want to completely export to another database. When I do that the primary keys i.e. Table Identity columns are getting lost. Why is this so. How can I import or export databases without loosing those.The other thing is that when I export the database the new one is only 4 MB large. The original is 35 MB large. I know this is becuse of the log ifle. How to empty this thing? I used the shrink database from the tasks and it croped the free space. How can I reasign more free space to one database.Thanks! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-24 : 11:35:54
|
| To copy the database do a backup and restore.For the tr log file seehttp://www.nigelrivett.net/TransactionLogFileGrows_1.html==========================================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. |
 |
|
|
|
|
|
Export/Import database