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 |
|
anaylor01
Starting Member
28 Posts |
 Posted - 2011-11-13 : 13:42:13
|
| I have a 1.3TB database. The previous guy didn't do any maintenance and now the server is about to crash. The tables needed to be partitioned the indexes needed to be dropped and created. I have done the maintenance on a copy of production but I need to somehow get the newer data from production onto my cleaned database. Production can go down for a very small window. Any ideas how to do this? |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-13 : 16:31:39
|
| Use BCP or bulk import or import export wizard to copy data. |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-11-14 : 00:56:05
|
| You can restore the tlog backups from the prod.PBUH |
|
|
|
anaylor01
Starting Member
28 Posts |
Posted - 2011-11-14 : 12:29:31
|
| Sachin, I tried that but it gave me an lsn number error. Can you explain how to do that? |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-14 : 12:46:15
|
| I would do it on production step by step.I guess your main issue is the size of the database?Presumably you have at least enterprise edition so things can be done on-line.Do something that will release some space - probably means moving some things onto another disk, maybe adding a disk to do it.Partitioning isn't going to release any space or necessarily make things faster.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-11-14 : 12:51:09
|
quote:
Originally posted by anaylor01
Sachin, I tried that but it gave me an lsn number error. Can you explain how to do that?
What is the error ?PBUH |
|
|
|
anaylor01
Starting Member
28 Posts |
Posted - 2011-11-15 : 00:19:35
|
| The log or differential backup cannot be restored because no files are ready to rollforward |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-11-15 : 01:57:41
|
| Did you restore full,diff and log backups (except the last log backup) with no recovery option ?PBUH |
|
|
|
|
|
|
Question about maintenance