Ok, The SQL server my Database is currently on is going away. They are replacing it with a new SQL 2005. My database has been told to find a new home. No body asked me if it was ok.
I have another SQL 2000 Server to move my database to but I can't find any instructions that make since on the MSDN website. I've restored backup copies of databases to the same server but never done a complete move like this.
MSDN says i should use the ALTER DATABASE planned relocation procedure, Any body out there know what thier talking about? I've hunted for it and I could only find the suff in the SQL 2005 books online for ALTER DATABASE (TRansact-SQL). There was no mention of moving or relocation planned or otherwise in that section.
I need to move it soon or I'l have do DO a total rebuild and some of the data only exsist in my database now, since thier origninal souces are gone.
HELP!!!!!!!!!!!
I suggest you take a look at this kb:
http://support.microsoft.com/kb/314546
No comments:
Post a Comment