Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

unicode&restore

Status
Not open for further replies.
jotita

jotita

Programmer
Aug 19, 2002
19
AR
I want to restore a DB, but sql say me that unicode in backup (54) is diferent in SQL (52) and no restore.
How I could restore? I don't know the id.
 
Sort by date Sort by votes
Change the collation of the target dabase to that of the source. You could also create a new database with the collation of the backup one, restore it there and take it from there.
 
Upvote 0 Downvote
yes, but I dont know the id of the backup.
Exist a program to change this? or to view.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

intel233
  • Locked
  • Question
Backup/Restore DB from SQL issues
Replies
2
Views
99
intel233
intel233
dd2maker
  • Locked
  • Question
SQL server 2008 R2 backup restore issue
Replies
2
Views
90
dd2maker
dd2maker
TheBugSlayer
  • Locked
  • Question
Backu and restore of multiple filegroups
Replies
2
Views
83
TheBugSlayer
TheBugSlayer
bluto99
  • Locked
  • Question
Piecemeal Restore and database mirroring
Replies
2
Views
46
bluto99
bluto99
TheBugSlayer
  • Locked
  • Question
Need to restore to reporting server without log file/best way to create reporting server. 1
Replies
7
Views
73
SQLBill
SQLBill

Part and Inventory Search

Sponsor

Back
Top