April 6, 2010 at 9:23 am
I have been trying to restore a sql 2008 database to a sql 2005 database. I know you can't do it directly, and that you need to script the database and the data, then run the script on the sql 2005 box to do it.
I have been following this guide:
http://www.devx.com/dbzone/Article/40531/0/page/2
Which from searching seems to be the go to guide.
Everything seems to run just fine. I get the script file and with data scripted we are talking about 3.5 gig file.
I try opening the script file and get the error message
The template specified cannot be found. Please check that the full path is correct.
that message appears if I try opening the file from the hard drive / file system.
If I am in sql server manager studio I get this error message:
The operation could not be completed. Access is denied.
Any thoughts? Driving me nuts on why it won't open the script file and of course putting 3.5 gig script into word pad / clipboard won't work.
I really want to be able to script the data cause the systems are not joined, and "can't" be one is in house the other is web facing on a different host / network.
April 6, 2010 at 9:26 am
Please post the exact and complete error message you are getting. Can't diagnose a problem based on what you have posted.
April 6, 2010 at 9:37 am
mathomp3 (4/6/2010)
Everything seems to run just fine. I get the script file and with data scripted we are talking about 3.5 gig file.
Do it separately then. First script the database without data and then a script of just the data.
If I am in sql server manager studio I get this error message:
The operation could not be completed. Access is denied.
Was the script file generated on the same computer you are trying to open it or did it come from another source server? I say this in that you may need to check the file security of the script, maybe change ownership of the file to your user name.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 6, 2010 at 9:40 am
Sadly there are no other errors.
The generate script runs perfect no errors, creates the script clean. I take the file which is saved, push it up to the server. Once on the server I try and open the file from the file manager and I get this exact error:
The template specified cannot be found. Please check that the full path is correct.
So then I log into the SQL server with microsoft sql server management studio and choose open file and get this error message:
The operation could not be completed. Access is denied.
The account has full admin rights on the server and SA rights in the database.
I wish there was more information to give / go off of.
April 6, 2010 at 9:44 am
mathomp3 (4/6/2010)
Sadly there are no other errors.The generate script runs perfect no errors, creates the script clean. I take the file which is saved, push it up to the server. Once on the server I try and open the file from the file manager and I get this exact error:
The template specified cannot be found. Please check that the full path is correct.
So then I log into the SQL server with microsoft sql server management studio and choose open file and get this error message:
The operation could not be completed. Access is denied.
The account has full admin rights on the server and SA rights in the database.
I wish there was more information to give / go off of.
From my experience, this:
The operation could not be completed. Access is denied.
indicates a permissions issue.
Of course, I may be mistaken, but that is where I'd start checking.
April 6, 2010 at 9:47 am
I tried making security changes to the file with no luck on the access denied error.
I did try scripting just the database, and trying to get the structure to pass. I was able to get it to run but it ran into problems with tons of errors all similar to
Cannot find the object "dbo.Announcements" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
just keep changing the object part rest is the same.
Now that the database is partially generated should I try rescripting the 2008 database but leave off the create database part?
April 6, 2010 at 9:51 am
You will have to go through the script and adjust those parts that reference objects or commands that are not supported in SQL Server 2005.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 6, 2010 at 9:57 am
Ok update. I did the initial blank create of the database in sql 2005, then ran the scripts to build the table structure / roles / etc, without the data. Ran it against the sql 2005 and everything worked minus 1 stored procedure which is no longer in use by any system, so "success" Now I just need to script the data. any tips on that? Do I just false everything, but the data and set it to true? Since all the other scripts have ran correct?
April 7, 2010 at 8:16 am
Ok, I have the database, and I have the data, but I am missing the stored procedures and functions.
What scripting options do I need to choose to get those?
Thank you
April 7, 2010 at 11:34 am
http://mangalpardeshi.blogspot.com/2009/03/script-all-store-procedures-in-database.html
Good blog post on it...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply