2
votes
1answer
133 views

Restore sql server 2000 database to 2008

I am not a DBA. I will be doing this for the first time. So I am not sure what all I am supposed to do? I will be restoring sql server 2000 database to sql server 2008. Are there anywhere step by ...
1
vote
2answers
3k views

SQL Backup - Restoring to different data / log files - Changing file structure…?

I'm trying to restore a BAK of a database we have, onto new, better hardware. Here is a screenshot of the UI in Management Studio http://twitpic.com/wmtr8/full The existing db has an mdf, and ndf ...
2
votes
1answer
81 views

What causes inconsistent SQL 2K backups?

I take weekly full backups of a SQL 2000 database via vanilla Enterprise Manager. The problem happened when I tried to restore the database. I learn that it was not up-to-date as it was pointing ...
8
votes
8answers
28k views

SQL Server restore a backup results in an error

I have a database in dev (SQL Server 2005 on Windows Server 2008) that I need to move to prod (SQL Server 2000 on Windows Server 2003). My process is as follows: Login to dev, open SQL Server ...