Comprehensive data protection for all workloads
Post Reply
asris
Novice
Posts: 6
Liked: 2 times
Joined: Jan 13, 2016 8:53 pm
Full Name: ASRIS
Contact:

Restore sql table no primary or nonclustered

Post by asris »

I'm having an issue restoring a database table with a primary key constraint. Is it possible to restore a table without the PK? or nonclustered?

I can restore other tables fine that doesn't have a PK.
asris
Novice
Posts: 6
Liked: 2 times
Joined: Jan 13, 2016 8:53 pm
Full Name: ASRIS
Contact:

Re: Restore sql table no primary or nonclustered

Post by asris » 1 person likes this post

As it turns out you can't restore a table (with a different name) that has a Primary Key. You'll either have to remove/rename the PK or the original table before restoring.

We ended up renaming the original PK, then restored the table. Renamed the restored table's PK, and renamed the original one back.
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 59 guests