jangan langsung direstore ke SQL Server 2008, coba menggunakan export/import dari komputer yang ada instalasi SQL Server 7 ke komputer yang ada instalasi SQL Server 2008
--- On Mon, 10/4/10, Nugroho Triyananto <[email protected]> wrote: From: Nugroho Triyananto <[email protected]> Subject: [ITCENTER] Restore DataBase sql server To: [email protected] Date: Monday, October 4, 2010, 11:30 PM mau tanya rekan2 IT center, saya mau memindahkan database dari sql server 7 ke sql server 2008,kenapa tidak bisa yah? apakah rekan2 ada solusinya?? ini error yang muncul : -------TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'MR_PUTUT'. (Microsoft.SqlServer.SmoExtended) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: The database was backed up on a server running version 7.00.1063. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------------------ -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [email protected] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
