PDA

View Full Version : سوال: ارور موقع انتقال دیتابیس ASPNETDB.MDF به هاست



dontspeak
یک شنبه 26 تیر 1390, 01:25 صبح
سلام دوستان من قبلا هم سوال پرسیده بودم ولی کسی جواب نداد. من موقع انتقال دیتابیس ASPNETDB.MDF به هاست با ارور مواجه میشم. من اول یه فایل sql از دیتابیسم درست میکنم بعد اطلاعاتش رو کپی می کنم داخل دیتابیس هستم. وقتی excute رو میزنم همه درست اجرا میشن ولی چند ارورهاش اینها هستن.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 53
Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 58
Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 87
Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 92
Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles, Line 48
Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles, Line 52
Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles, Line 79
Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles, Line 83
Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles, Line 93
Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'aspnet_UsersInRoles_AddUsersToRoles', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'aspnet_UsersInRoles_RemoveUsersFromRoles', because it does not exist or you do not have permission.

sql server هاست 2008 هست.

ahmad2asp
پنج شنبه 22 دی 1390, 18:56 عصر
منم می خوام ASPNETDB.MDF رو آپلود کنم.
فقط می دونم باید از بک آپ و ری استور استفاده کنی و فایل بک آپ رو تو هاست ری استور کنی.
و برای بک آپ گیری هم باید sql manegment express رو نصب کنی یا از sql server استفاده کنی.
من منجمنت رو نصب کردم ولی برای اینکه ازش استفاده کنم با مشکل مواجه شدم.

crazy_1892
پنج شنبه 22 دی 1390, 19:05 عصر
راحترین کار استفاده از backup و reastor است

برای backup هم از همون کنترل پنل هاست اسفاده کنید

چه مشکلی با sql manegment بر خوردین؟؟؟