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 |
|
staplebottom
Starting Member
29 Posts |
 Posted - 2009-07-19 : 16:05:54
|
| Hi,I am considering moving hosts and I want to backup my db, but without the full text as my new host wnt let me restore the db if it has full text indexes. I have tried to do a full backup and only select the database file but the control panel on my new host still tells me the backup has full text indexes. Do I have to remove them from my live database to do this backup? This means my search will be down and ill have to rebuild them?Thanks,Conor |
|
|
jowens
Starting Member
1 Post |
Posted - 2009-07-24 : 12:18:39
|
I've got the exact same issue. Any way around this guys? Anyone? Bueller...Bueller...Bueller...LOL.quote:
Originally posted by staplebottom
Hi,I am considering moving hosts and I want to backup my db, but without the full text as my new host wnt let me restore the db if it has full text indexes. I have tried to do a full backup and only select the database file but the control panel on my new host still tells me the backup has full text indexes. Do I have to remove them from my live database to do this backup? This means my search will be down and ill have to rebuild them?Thanks,Conor
|
 |
|
|
staplebottom
Starting Member
29 Posts |
Posted - 2009-07-24 : 12:24:58
|
| What I ended up doing was deleting the full text, then disabling full text on the db. Then I did my backup. Then i created all the full text stuff again. It was ok once you have all the sql query saved. Done in minutes. |
|
|
|
|
|
|
backup without full text