I don't think you're going to be able to do this without at least a momentary interruption to service as you switch to a different database server. You might...

rhat (10/15/2007)

---

I have been using SQL Server for around 8 years and I have never, ever had to use a DBCC command. Why? Because I backup regularly and I design...

Back up your databases and restore them on the new server. Lots of discussion about stuff like that on this site. Likewise, you should also be able to...

Sandy

This behaviour is documented in Books Online. Have a look at this topic:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/248df62a-7334-4bca-8262-235a28f4b07f.htm

John

Stephen

Use the ROW_NUMBER function. You'll find it in Books Online and there are some examples of how to use it in there as well.

John

Ewan

Are you saying you have two instances on the same computer: a default instance and a named instance called mssqlserver?

John

Ed

Did you check the destination file for triggers? Is there an error message? Have you checked the errorlog and the Windows Event Log? Try opening the text...

Ed

Have you worked out which rows are missing to see whether they have anything in common? Is it the last 1656 rows from the text file? Is there...

Do you have a backup of your database when it was 512MB? If so, perhaps you could restore it to another server, or on the same server with a...

There is another way, and that's to use the information in sysreferences and sysconstraints (I think) to write a script that will give you the tables in a hierarchical order....

One way of doing it, if you have the patience, is to use the database diagram tool in Enterprise Manager. This will show you which tables have relationships with...

roger clarke (6/20/2007)

---

Well, I'm afraid I am not at all impressed with this article ... just one more example of the painting by numbers crowd who will never really get...

Frank

Please will you post the RESTORE statement your trying and the exact error message it returns.

Thanks

John

Jon

How about a job that runs every day at midnight and checks the values in the StartDate column against today's date and copies them over if it's identical? Here's...

Sorry, I don't understand what you mean by "from 2 days". What sort of database is it, how many users use it and what sort of transactions does it...