I am new to SQL Server 2005, I have 5-6 years of experience with SQL Server 2000. I am mainly a Sybase database guru. I have a Sybase database about 3.5GB, that I need to recreate in an empty SQL Server database. Instead of creating empty tables and using bulk copy to reload the data, is it possible to reload the Sybase database into the empty SQL Server database? If so, how? If not, what does everyone recommend? Please let me know.
I don't think you are going to be able to load a Sybase DB via restore database in SQL Server. I think you are going to have to go the SSIS route, or extract DDL/create and then BCP/Bulk Load data to the tables.
I just installed SSMA for Sybase on my laptop. When I tried to run it, the type Initializer for SSMA threw an exception and kicked me out. Has anyone seen this error before? Was I suppose to reboot my laptop? Where I can go to get past these issues?
An exception means that an error occured in the program.
When this happens, you need to note the error carefully (screen shots help a lot with this). Check the appropriate error logs. In this case, I'd check the wizard's log, SQL Server's error log, and all of the Windows even logs.
There is almost always a message that describes the error. The information provided about that error (both from the message on the screen and from the appropriate logs) will help us a lot as we try to help you resolve the problem.
I don't have a machine with me that is adequately "armored" to open a *.DOC file from a stranger, so I can't see your screen shot.
Based on the contents of the error log, it looks to me like a startup argument was provided (for the SSMA executable) that was improperly formatted.
I'll take a look at this in more detail tonight, but you might want to try to:
a) Run SSMA again with different parameters
2) Remove and reinstall SSMA
3) Install SSMA on a different machine, preferably with a different OS release.
4) A reboot can't hurt, but probably won't help by itself.
I was able to successfully load my tables using the Bulk Insert SQL command, I was hung up a little bit on finding the right delimiter. Anyways, I need to backup my database, however, I am receiving an error message when I am trying to backup the database using right-click->Task->Backup and the below SQL Backup command:
BACKUP DATABASE Intranet
TO DISK = 'c:\SQL Backups\Intranet.Bak'
MEDIANAME = 'Intranet',
NAME = 'First Full Backup of CSA-Intranet';
I am receiving this error message when attempting to backup the database both ways -
Msg 3271, Level 16, State 1, Line 2
A nonrecoverable I/O error occurred on file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Intranet.mdf:" 23(Data error (cyclic redundancy check).).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
The data file for the Intranet database does exist at the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Intranet.mdf location. What am I missing here? Any further help would be appreciated.
Something went bad within the data file itself. One or more of the data pages is corrupt so the CRC is incorrect.
This is a problem that I almost never see (I've actually only seen it on workstations, never on a server).
The best answer by far for your specific circumstances would be to rebuild the database from scratch using BCP. The problem can definitely be fixed, but without knowing how it occured I'd much rather avoid dealing with it than trying to fix it.
The physical data device of my database was corrupted somehow. Luckily, I was able to find and replace bad sectors of the database device file using the chkdsk utility with repair option after waiting 90 minutes for chkdsk to analyze my entire laptop. Then, I was able to perform a backup of the database in question.