thanks Craig. Already tried with the same outcome. 1. restoring a sharepoint site (Y) including the content db using UI/STSadm, it can create the site but fails when attaching/Adding db after restoring the db. 2. attaching/Add the content db from a restored db using STSadm, fails straight away Same error on both, as it does the same task. One thing i read somewhere about version nos in version table and table and procedure count mismatch, unfortunately not sure it applies in this scenario. How does sharepoint evaluate schema versions and its changes?
________________________________ From: [EMAIL PROTECTED] on behalf of Craig Stevens Sent: Mon 9/22/2008 1:00 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: Restore issue .. How are you restoring the db? I've found the best way is to create a new application in the new server, including creating a new database. Then using a batch command similar to below to delete the newly created database and replace it with the restored database. cd \Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\ STSADM -o deletecontentdb -url http://ATLAS -databasename WSS_Content1 -databaseserver ATLAS\sqlexpress STSADM -o addcontentdb -url http://ATLAS -databasename WSS_Content4 -databaseserver ATLAS\sqlexpress Cheers Craig From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zakir Azeez Sent: Monday, 22 September 2008 12:08 PM To: listserver@ozMOSS.com Subject: RE: Restore issue .. G'day oz-Mossers, Anyone care to shed some light here.. Scenario: Restore full Site collection from one farm to another farm including Content DBs. Error: <Database> on <Server> contains user-defined schema. Databases must be empty before they can be used. Delete all of the tables, stored procedures and other objects or use a different database Tried both options 1. restoring a sharepoint site (Y) including the content db 2. attaching the content db from a restored db Additional Information: - There is no schema change happened manually. - Exporting Site X (subwebs) to Site Y (Subwebs), - Backed up Y using stsadm/UI - Restoring on another (new) farm. (I am getting error here) What am i missing? Let me know if more details are required.. Thanks, Zak ________________________________ From: [EMAIL PROTECTED] on behalf of Paul Noone Sent: Mon 9/22/2008 10:47 AM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: Using static tokens for URLs within Layout Pages Sorry, guys. I hate to bug but have tested this extensively and this solution simply isn't work for me. Maybe it's because I'm trying to use it in a Layout Page? When I use the token on its own it seems to work just fine. But as soon as I append a path to it the token gets printed literally as seen below. This: <a href="<% $SPUrl:~SiteCollection/ %>test" runat="server">Intranet</a> Produces this: http://moss/SiteDirectory/Pages/%3C%%20$SPUrl:~SiteCollection/%20%%3Etest <http://moss/SiteDirectory/Pages/%3C%25%20$SPUrl:~SiteCollection/%20%25%3Etest> Instead of this: http://moss/test Please tell me I'm just doing something stupid and this can be easily resolved. Thanks, Paul -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeremy Thake Sent: Tuesday, 16 September 2008 4:25 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: Using static tokens for URLs within Layout Pages Found this: http://theotherscott.blogspot.com/2008/03/sharepoint-link-to-top-of-site.html Cheers, Jeremy Thake Readify | Senior Consultant Perth | WA 6005 | Australia M: +61 400 767 022 | E: [EMAIL PROTECTED] | W: www.readify.net | B: www.made4the.net ________________________________________ From: [EMAIL PROTECTED] [EMAIL PROTECTED] On Behalf Of Paul Noone [EMAIL PROTECTED] Sent: Tuesday, 16 September 2008 12:06 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: Using static tokens for URLs within Layout Pages Hi Brian, Adding the missing tag prefixes and using the link code provided produces the following error: An error occurred during the processing of /_catalogs/masterpage/CEO-SiteDirectory-tabs.aspx. Literal expressions like '<% $SPUrl:~sitecollection %>' are not allowed. Use <asp:Literal runat="server" Text="<%$SPUrl:~sitecollection%>" /> instead. If I add the runat="server" attribute to the link tag it produces literal strings. Same goes if I use the suggested ASP literal tags above. Any other suggestions as to why it's not getting translated? Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Farnhill Sent: Tuesday, 16 September 2008 1:13 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: Using static tokens for URLs within Layout Pages Have you tried something like this: <a href="<% $SPUrl:~sitecollection%>/SiteDirectory/SitesList/NewForm.aspx?Source=<% $SPUrl:~sitecollection%>%2FSiteDirectory%2FPages%2Fcategory%2Easpx">Add Site</a> You will need to reference the following in your page though for this to work: 1: <%@ Register Tagprefix="PublishingWebControls" Namespace="Microsoft.SharePoint.Publishing.WebControls" Assembly="Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> 2: <%@ Register Tagprefix="PublishingNavigation" Namespace="Microsoft.SharePoint.Publishing.Navigation" Assembly="Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> 3: <%@ Register TagPrefix="PublishingVariations" TagName="VariationsLabelMenu" src="~/_controltemplates/VariationsLabelMenu.ascx" %> 4: <%@ Register Tagprefix="PublishingConsole" TagName="Console" src="~/_controltemplates/PublishingConsole.ascx" %> 5: <%@ Register TagPrefix="PublishingSiteAction" TagName="SiteActionMenu" src="~/_controltemplates/PublishingActionMenu.ascx" %> I had a post on my blog about this as well - it's at http://pointstoshare.spaces.live.com/blog/cns!AEC42F315B4528B0!2911.entry Brian Farnhill Consultant Technical Consulting Direct: 02 6225 4307 Main: 02 6225 4333 Mobile: 0408 289 303 Fax: 02 6225 4334 Email: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> Web: www.uniqueworld.net<http://www.uniqueworld.net <http://www.uniqueworld.net/> > Blog: pointstoshare.spaces.live.com<http://pointstoshare.spaces.live.com/> Microsoft Certified Application Developer [cid:image001.jpg@01C91805.52798AD0] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Noone Sent: Tuesday, 16 September 2008 12:32 PM To: listserver@ozMOSS.com Subject: [OzMOSS] Using static tokens for URLs within Layout Pages Does anyone know if it's possible to use the ~sitecollection and ~site tokens within the content placeholder of a Layout Page in order to provide dynamic URLs at run-time? We are providing some custom elements within the pages and I'm trying to avoid having to update the absolute URLs when we move to production. e.g. <asp:Content ContentPlaceholderID="PlaceHolderMain" runat="server"> <div class="ms-globalright ms-toolbarContainer"> <a href="~sitecollection/SiteDirectory/SitesList/NewForm.aspx?Source=~sitecollection%2FSiteDirectory%2FPages%2Fcategory%2Easpx">Add Site</a> </div> ... Kind regards, Paul ________________________________ ____________________________________________________________________________ This e-mail is intended for the use of the addressed recipient(s) only and may contain confidential and privileged information. If you have received this message in error, please delete the message and any attachments and copies immediately; and notify the sender by return e-mail. Any views expressed in this message or any attachments are those of the individual sender and do not necessarily represent the corporate opinion of the Catholic Education Office (CEO), Sydney. The CEO Privacy Policy is located at http://www.ceo.syd.catholic.edu.au <http://www.ceo.syd.catholic.edu.au/> ____________________________________________________________________________ ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ________________________________ ____________________________________________________________________________ This e-mail is intended for the use of the addressed recipient(s) only and may contain confidential and privileged information. If you have received this message in error, please delete the message and any attachments and copies immediately; and notify the sender by return e-mail. Any views expressed in this message or any attachments are those of the individual sender and do not necessarily represent the corporate opinion of the Catholic Education Office (CEO), Sydney. The CEO Privacy Policy is located at http://www.ceo.syd.catholic.edu.au <http://www.ceo.syd.catholic.edu.au/> ____________________________________________________________________________ ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
<<winmail.dat>>