Recent content by OrnSveinsson

  1. O

    The problem with SQL after migrating the database to another machine

    May be this article will give you more information. http://www.techrepublic.com/forums/questions/it-seems-our-sql-database-is-corrupted/
  2. O

    The problem with SQL after migrating the database to another machine

    If that doesn't work, try to restore a database by third-party tools. You can find them a lot in Google. If you don't want to spend the time looking, you can try a proven tool SQL Server Recovery Toolbox. All the details about this program can be found at the link...
  3. O

    The problem with SQL after migrating the database to another machine

    Copy your backup file to the other server, and there do: RESTORE DATABASE MyDatabase FROM DISK = 'E:\Backups\MyDatabase.bak' WITH FILE = 1, MOVE 'MyDatabase_Data' TO 'E:\SQLDATA\MyDatabase_Data.mdf', MOVE 'MyDatabase_Log' TO 'E:\SQLLOG\MyDatabase_Data.ldf', NOUNLOAD, REPLACE, STATS = 10...
  4. O

    The problem with SQL after migrating the database to another machine

    Try doing the backup and restore via SQLCMD (or via a query window in SQL Server MS). The backup would be as follows (obviously, change "MyDatabase" and "D:\BACKUPS" to whatever database and location you want to back up - just using for example): BACKUP DATABASE MyDatabase TO DISK =...