| Author |
Topic |
|
nathonjones
Starting Member
15 Posts |
 Posted - 2010-08-10 : 09:17:37
|
| We have a .sql text file which was a back-up we took from a third party hosted SQL database we used to have. This file is almost 70MB.We desperately need to restore the data but we have no idea how to do so and our previous host refuses to tell us how this is done, despite advising us to back up the data in the way that we have.I'd really appreciate any advice that could be offered. Thank you.RegardsNath. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-08-10 : 09:25:38
|
Do you have a clue how the data is looking inside that file?Maybe there are lot of create table and insert statements?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-10 : 10:52:38
|
| If it was made from SQl 2008 it may be a script containing commands to create the database, tables AND insert the data - one row at a time.If you are certain that the version of SQL was earlier (SQL2005 or before) then there was no included method for doing this - so it would have to have been using a 3rd party tool of some sort.The other possibility is that it is a Backup file - which would be Binary, rather than text - and thus gobbledegook when you look at it. If that's the case its relatively easy to Restore from.What version of SQL Server are you using?Ans assuming you didn't go out of your way to fall out with the hosting company! who was it? - so I can add them to me avoid list |
|
|
|
nathonjones
Starting Member
15 Posts |
Posted - 2010-08-10 : 12:02:11
|
| It says it's a "Microsoft SQL Server Query File" and I'm pretty sure it was SQL2005 at the time (November 2008).The host was Fasthosts, and they didn't upgrade to SQL2008 until quite recently.When I double click the file it opens Microsoft SQL Server Management Studio and shows me the entire file. Here's a sample of the first 30-40 lines:/****** Object: StoredProcedure [dbo].[dt_getobjwithprop_u] Script Date: 10/16/2008 17:01:14 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER OFFGOIF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dt_getobjwithprop_u]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)BEGINEXEC dbo.sp_executesql @statement = N'/*** Retrieve the owner object(s) of a given property*/create procedure [dbo].[dt_getobjwithprop_u] @property varchar(30), @uvalue nvarchar(255)as set nocount on if (@property is null) or (@property = '''') begin raiserror(''Must specify a property name.'',-1,-1) return (1) end if (@uvalue is null) select objectid id from dbo.dtproperties where property=@property else select objectid id from dbo.dtproperties where property=@property and uvalue=@uvalue' ENDFurther down the file, I can see the old table structures and table data. Again, here is an example of that...GO/****** Object: Table [dbo].[TRADproducts] Script Date: 10/16/2008 17:01:14 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[TRADproducts]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)BEGINCREATE TABLE [dbo].[TRADproducts]( [productID] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [prodcategory] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [prodsubcategory] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [productname] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [productimage] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [productimagetmb] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [suppliername] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [price] [money] NULL, [weight] [int] NULL, [include] [bit] NOT NULL, [feature] [bit] NOT NULL, [specialoffer] [bit] NOT NULL, [numbersold] [int] NULL)ENDGOINSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'25L01', N'Straps', N'Leather', N'Planet Waves Leather Strap', N'2.5 inches wide, plain tan, adjustable leather strap. Planet Waves leather guitar straps are made of high-quality leather, and are as comfortable as they are durable.', N'straps/25L01.jpg', N'straps/25L01tmb.jpg', N'Summerfield', 11.0000, 170, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'82155', N'DVD', N'Gael Force Dance', N'Gael Force Dance - The Irish D', N'Filmed in Belfast, Gaelforce Dance is an Irish dance spectacular similar to the fantastic Riverdance. Sensual and dramtic, it has brought over one million people to their feet worldwide with its energy, grace, passion and mix of original traditional and contemporary Irish dance music. <b>Region 0</b>', N'dvds/gaelforcespectacular.jpg', N'dvdstmb/gaelforcespectacular.jpg', N'Highlander Music', 13.9900, 100, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'82501', N'DVD', N'Great Irish Singalong', N'Great Irish Singalong', N'The best of Irish traditional music mixed with scenes of some of Ireland''s best-loved beauty spots. Includes tracks:<br><br>Whiskey In The Jar<br>Silver Spear<br>Danny Boy<br>The Irish Rover<br>and many more...<br><br> <b>This DVD is playable worldwide.</b>', N'dvds/greatirishsingalongdvd.jpg', N'dvdstmb/greatirishsingalongdvd.jpg', N'Highlander Music', 8.9900, 100, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'82503', N'DVD', N'Irish Myths & Legends', N'Irish Myths & Legends', N'This program focuses on the grand history of Ireland, exploring some of its most famous sites and legends. From the coast to the hills, viewers can take in lush scenery and a visual tour of these impressive sites. Stories include the legend of Blarney Castle, Tara, and Ballintubber Abbey.Deleted 30/11/2007', N'dvds/irishmythsandlegends2.jpg', N'dvdstmb/irishmythsandlegends2.jpg', N'Highlander Music', 8.9900, 100, 0, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'82507', N'DVD', N'Whistle Stop Edinburgh', N'Whistle Stop Edinburgh', N'A guide to the visitor attractions of Edinburgh, including the Castle, Holyrood Park and Princes Street.<br><br><b>This DVD is playable worldwide.</b>', N'dvds/whistlestopedinburghdvd.jpg', N'dvdstmb/whistlestopedinburghdvd.jpg', N'Airheart Records', 9.9900, 100, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'82511', N'DVD', N'On The Whisky Trail', N'On The Whisky Trail', N'Whisky and Scotland go together and this program will introduce the special relationship between these two to the uninitiated. The whisky industry is quite large in Scotland, and you will learn about it''s fascinating history here. <b>PAL Region 0</b>', N'dvds/onthewhiskytrail.jpg', N'dvdstmb/onthewhiskytrail.jpg', N'Highlander Music', 9.9900, 100, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'82617', N'DVD', N'The Irish Prayers', N'The Irish Prayers', N'Irish prayers set to music. They derive from the Middle ages and they were collected and written down by Benedictine friars from Ireland.', N'dvds/irishprayers.jpg', N'dvdstmb/irishprayers.jpg', N'Highlander Music', 7.9900, 100, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'82693', N'DVD', N'Great Scottish Singalong', N'Great Scottish Singalong', N'Tour the magnificent country and sing along with some of the classic songs of Scotland. Filmed on location in Scotland this programme raises a glass to toast this great nation. Exploring the wonderful countryside while presenting Scotland in song, the programme allows you to join in with classics such as:<br><br>Auld Lang Syne<br>Flower of Scotland<br>The Willow Tree<br>and many more...<br><br><b> PAL region 0</b>', N'dvds/greatscottishsingalong.jpg', N'dvdstmb/greatscottishsingalong.jpg', N'Highlander Music', 8.9900, 100, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'82706', N'DVD', N'Great Irish Drinks', N'Great Irish Drinks', N'Soak in the rich hospitality of the Emerald Isle. This documentary attempts to provide a comprehensive account of the special Irish drinks brewed in ancient breweries, providing recipes for some of the most tranquilizing ones. <b>This DVD is playable worldwide.</b>', N'dvds/greatirishdrinksdvd.jpg', N'dvdstmb/greatirishdrinksdvd.jpg', N'Highlander Music', 8.9900, 100, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'AI82501', N'DVD', N'Scottish', N'Aly Bain and Phil Cunningham', N'Dual Format DVD. Should be playable on any machine supporting either PAL or NTSC format.<br><br>This concert was recorded in 2002 on the last night of Shetland fiddler Aly Bain and accordionist Phil Cunningham''s 12th tour of Scotland. This duo of master musicians played a fantastic concert set much enjoyed by the enthusiastic crowd. Also includes documentary, biographies and discographies.<br><br>1. Stella''s Trip to Camloops • Memories of Father Angus Macdonald • Laird of Drumblair • Cambridge Hornpipe<br>2. Estonian Waltz • All Round the World and Back Again • La Bastringue<br>3. Sarah''s Song<br>4. Charlie Hunter''s Jig • The Mouse In the Cupboard • Rosewood<br>5. Annelese Bain • Phil Cunningham''s Reel • Andy Brown''s Reel<br>6. Bonaparte''s Retreat<br>7. Shores of Loch B • Headlands • Floggin<br>8. Jig Runrig • Swedish Jig<br>9. Swedish Hymn • Norwegian Hymn • Louis Waltz<br>10. Logan Water<br>11. Flett for Flotta • Saol Iain NicUisdhean • The Drampire • Aly''s Sound<br>12. Violet Tulloch Queen of Lerwick<br>13. The Auld Fiddler • Earl Mittens Breakdown<br>14. Margaret''s Waltz • Donald Maclean''s Farewell to Oban • Fairy Dance<br>15. Sitting On the Stern Of a Boat', N'dvds/alybainphilcunningdvd.jpg', N'dvdstmb/alybainphilcunningdvd.jpg', N'Highlander Music', 14.5000, 170, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'AV800-3', N'Strings - Viola', N'Viola', N'Astrea Viola Strings', N'A String<br>D String<br>G String<br>C String', N'violastrings/astrea.jpg', N'violastrings/astreatmb.jpg', N'The Sound Post', 9.2900, 220, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'BKDV201', N'Videos', N'Calasaig - Beginnings', N'Calasaig - Beginnings', N'Charting the groups progress from it''s early days in Scotland to their first tour of North America and appearance at Celtic Connections in Glasgow, ''Beginnings'' provides an interesting insight and ''behind the scenes'' look at Calasaig; featuring an eclectic mix of travel, concert, radio and television footage set amidst the stunning natural beauty of the highlands of Scotland and the cosmopolitan appeal of Toronto.<br><br>With music by Calasaig & narration by Rod Morison.<br><br>Tracks include:<br>Because<br>The Dancer/Philip Begg''s/John Murray''s<br>Arthur McBride<br>Ramsden''s Rant/Laura Beaton''s Reel/Cough Up The Donal<br>How Can My Poor Heart<br>The Irish Set<br>Heights of Cassino/The Foxhunter''s/The Alien Piper<br>Jimmy Ward''s/Hardimann the Fiddler<br>Waes Me for Prince Charlie<br>Thig Am Bata<br>Major Mally''s<br>Listening in at Montgomery''s Tavern<br>Farewell to Whisky<br><br>Available only in UK PAL format.', N'videos/beginningsvideocalasaig.jpg', N'videos/beginningsvideocalasaigtmb.jpg', N'Keith Johnston', 11.9900, 220, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'Brechinbook01', N'Books', N'Scottish Accordion Tunes', N'Out of his Mind', N'''Out of his Mind'' 65 Contemporary Compositions for the Scottish Accordion all written by Accordion Wizard Sandy Brechin.', N'videos/outofhismind.jpg', N'videos/outofhismindtmb.jpg', N'Sandy Brechin', 11.0000, 200, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'BrechinVid01', N'Videos', N'Sandy Brechin''s Learn Scottish', N'Sandy Brechin''s Learn Scottish', N'Scottish Accordion Instructional Video released by Accordion wizard Sandy Brechin which contains six structured lessons featuring tunes, tips and techniques aimed at intermediate players.<br><br>Discover the techniques which characterise Scottish accordion music as you play through a repertoire of Scottish folk tunes. The lessons are structured to help you learn at your own pace, and designed for students with moderate to advanced skills.<br>Packed full of close-ups, tunes, master tips and techniques, this video comes with a tune book and access to a helpful internet site.', N'videos/scottishaccordiontmb.jpg', N'videos/scottishaccordiontmb.jpg', N'Sandy Brechin', 16.9900, 220, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'BRPubProp', N'Instrument Stands', N'Multi-Purpose', N'The Pub Prop', N'<img src="../productimages/accessories/pubprop/pubpropmandolin.jpg" align="right" hspace="8" border="1">Never let your instrument fall over again with The Pub Prop, a unique pocket sized table-mounted support for:- Guitars, Mandolin, Violin & Bow, Bouzouki, Cittern, 5 String Banjo and Octave Mandola. Fastens to most tables up to 2" thick, and also horizontal rails up to 2" square.<br><br>Secures violins and their bows by using a small adaptor fitted to the strap of the Prop. The Mandolin adaptor suits slim-necked instruments.<br><br><div align="center"><img src="../productimages/accessories/pubprop/pubprop.jpg" border="1"></div><br><br>It packs flat, is lightweight, comes with its own case and is easy to assemble.', N'accessories/pubprop/pubpropguitar.jpg', N'accessories/pubprop/pubproptmb.jpg', N'Stones Music Ltd', 12.0000, 170, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'CALDHU001', N'Calendars', NULL, N'Canndhu 2004 Folk Calendar', N'A beautiful calendar, put together by artist Linda McCann in conjunction with Michael Garden. They have created the most collectable and fun folk calendar ever which features models of twelve of the biggest and most dynamic acts in traditional music:<br><br><b>Phil Cunningham & Aly Bain<br>Alison Brown<br>The Dubliners<br>Flook<br>Altan<br>Shooglenifty<br>Lunasa<br>Dougie MacLean<br>Michael McGoldrick<br>Malinky<br>Kate Rusby & John McCusker<br>Joe Burke & Sharon Shannon</b>', N'books/mccann/calendar2.jpg', N'books/mccann/calendartmb.jpg', N'Canndhu Productions', 5.0000, 200, 0, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'CCRD003', N'DVD', N'Colin Campbell''s Local Radio', N'Colin Campbell''s Local Radio V', N'Tracks include:<br><br>1. Donnie The Dounreay Rabbit<br>2. Local Radio Mastermind<br>3. Shorepath To Kyle<br>4. Hedgie McPrickle<br>5. Unfair Dismissal<br>6. The Flow Country<br><br>Colin Campbell’s hilarious ‘local’ radio stations are as popular as ever, and his social comment just as acute. On this comedy DVD Colin pokes fun at his own Highlands with songs, tunes, sketches and skits.Deleted 30/11/2007', N'dvds/colincampbelldvdvol13.jpg', N'dvdstmb/colincampbelldvdvol13.jpg', N'Highlander Music', 15.9900, 100, 0, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'D13000090', N'DVD', N'Drumming', N'Learn Pipe Band Drumming (PAL)', N'Learn Pipe Band Drumming features three top Grade 1 players, John McFetridge (Field Marshal Montgomery- Bass drummer), Scott Currie (Strathclyde Police Pipe Band- Tenor drummer), Brian McComish (Boghall and Bathgate Caledonia Pipe Band- Snare drummer).<br><br>The DVD gives an excellent visual insight of Bass, Tenor and Snare drumming enabling the viewer/pupil to work through basic rudiments and learn a traditional 2 parted 2/4 march.<br><br>This DVD already has received tremendous interest as there are very few products, if any at all, that cover basic drumming rudiments while incorporating the three disciplines in pipe band drumming.<br><br>Both recordings have been produced by Murray Blair.<br><br><b>This unique DVD is available in PAL and NTSC.</b>', N'dvds/learnPBdrummingdvd.jpg', N'dvdstmb/learnPBdrummingdvd.jpg', N'RG Hardie', 24.0000, 170, 0, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'D13000101', N'DVD', N'Drumming', N'Learn Pipe Band Drumming (NTSC', N'Learn Pipe Band Drumming features three top Grade 1 players, John McFetridge (Field Marshal Montgomery- Bass drummer), Scott Currie (Strathclyde Police Pipe Band- Tenor drummer), Brian McComish (Boghall and Bathgate Caledonia Pipe Band- Snare drummer).<br><br>The DVD gives an excellent visual insight of Bass, Tenor and Snare drumming enabling the viewer/pupil to work through basic rudiments and learn a traditional 2 parted 2/4 march.<br><br>This DVD already has received tremendous interest as there are very few products, if any at all, that cover basic drumming rudiments while incorporating the three disciplines in pipe band drumming.<br><br>Both recordings have been produced by Murray Blair.<br><br><b>This unique DVD is available in PAL and NTSC.</b>', N'dvds/learnPBdrummingdvd.jpg', N'dvdstmb/learnPBdrummingdvd.jpg', N'RG Hardie', 24.0000, 170, 0, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'DA46', N'Books', N'The Lawrie Collection', N'The Lawrie Collection - The La', N'Tunes composed by three generations of the Lawrie Family. Pipe Major Willie Lawrie (1881 - 1916) won many composition competitions, and with tunes like The Battle Of The Somme, The Pap Of Glencoe and Captain Carswell it isn''t hard to see why. Ian Lawrie (1913 - 1987) was a champion piper, and his son Willie is a champion accordion player! 77 tunes in total in treble clef with chords.', N'blank.gif', N'albumcoverstmb/blank.gif', N'Highlander Music', 9.9900, 250, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'DEMONDVDB001', N'DVD', NULL, N'The World Of Foster and Allen', N'01. Everything Is Beautiful<br>02. Sweet Forget Me Not<br>03. Don''t Let The Stars Get In Your Eyes<br>04. Among The Wicklow Hills<br>05. The Gypsy Rover<br>06. A Mother''s Way<br>07. Born To Be With You<br>08. Galway Bay<br>09. Mursheen Durkin<br>10. Lonely But Only For You<br>11. Lord Of The Dance<br>12. If I Had My Life To Live Over<br>13. You Stand All Alone<br>14. Cottage In The Country<br>15. Jigs: The Knights Of St. Patrick - The Irish Washer Woman<br>16. Still<br>17. The Wabash Cannonball<br>18. Danny Boy<br>19. One Hundred Children<br>20. Partners In Rhyme<br><br>A great gift for all their fans. Twenty tracks, and on the DVD eleven bonus tracks, plus out-takes! Nearly two hours of great songs from this well-loved duo. Danny Boy, Mursheen Durkin, The Old House, One Day At A Time.', N'dvds/thewofosterandallen.jpg', N'dvdstmb/thewofosterandallen.jpg', N'Highlander Music', 10.0000, 100, 1, 0, 0, 0)INSERT [dbo].[TRADproducts] ([productID], [prodcategory], [prodsubcategory], [productname], [description], [productimage], [productimagetmb], [suppliername], [price], [weight], [include], [feature], [specialoffer], [numbersold]) VALUES (N'DEMONVHSB001', N'Videos', NULL, N'The World Of Foster and Allen', N'01. Everything Is Beautiful<br>02. Sweet Forget Me Not<br>03. Don''t Let The Stars Get In Your Eyes<br>04. Among The Wicklow Hills<br>05. The Gypsy Rover<br>06. A Mother''s Way<br>07. Born To Be With You<br>08. Galway Bay<br>09. Mursheen Durkin<br>10. Lonely But Only For You<br>11. Lord Of The Dance<br>12. If I Had My Life To Live Over<br>13. You Stand All Alone<br>14. Cottage In The Country<br>15. Jigs: The Knights Of St. Patrick - The Irish Washer Woman<br>16. Still<br>17. The Wabash Cannonball<br>18. Danny Boy<br>19. One Hundred Children<br>20. Partners In Rhyme<br><br>A great gift for all their fans. Twenty tracks - Nearly two hours of great songs from this well-loved duo. Danny Boy, Mursheen Durkin, The Old House, One Day At A Time.Really appreciate your input. I hope you can shed some light on the matter. Thank you.RegardsNath. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-08-10 : 12:48:56
|
| Open it in management studio, create a new database, change context to that database, run the script. Wait. It's a script of the entire DB including data.--Gail ShawSQL Server MVP |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-10 : 12:55:25
|
| Before you run it (if not too late!) putSET NOCOUNT ONGOat the top. otherwise all the "1 row processed" messages will probably run your PC out of memory and crash the system.Search forUSEin the script. If there is a "USE SomeDatabaseName" in the script that might cause it to try to switch to that named database - and if that already exists then it would start clobbering that database. A USE statement would be at the top of the file, normally, so chances are that there aren't any - so just belt & braces.As this is a 70 MB script it will probably take a LONG time to run.It would help, and may be important, if you local SQL Server is configured for the collation "SQL_Latin1_General_CP1_CI_AS" - but its not the end of the world if not (there is a risk that some procedures will fail if the server does not match the database columns - but they can be fixed - its just one-more/less-thing-to-worry-about)Can't think of anything else - so fingers-crossed :) |
|
|
|
nathonjones
Starting Member
15 Posts |
Posted - 2010-08-10 : 20:26:48
|
Thank you Gail and Kristen,I've not done anything yet!  Yes Gail, it's the entire database. We were running Access for a directory website, which we outgrew. Database driven areas of our website were crashing.Fasthosts recommended upgrading to an MSSQL database and we use Microsoft SQL Server Management Studio to access that database which is held on the Fasthosts server.I'm therefore not sure I can create a new database without purchasing another from Fasthosts. This then gives me access to another connection in Microsoft SQL Server Management Studio so would I then run the script in there?Kirsten, when you say "clobbering that database"...is there a danger it will overwrite an existing database, if it had the same name, or maybe existing tables/views that have the same name?If there is a "USE SomeDatabaseName" in the script, what should I replace it with to prevent any problems occuring or, at least, reducing the risk of any problem/s occuring?If there's anything else you think I should watch out for, before proceeding, please let me know. Your assistance is very much appreciated. Thank you.RegardsNath. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-11 : 02:53:43
|
| The "USE SomeDatabaseName" command switches to that named database. In the absence of that the script will run in which ever database you are connected to. What you need is to connect to a new, empty, database, but checking for "USE" in the script will just double-check that it isn;t gogin to switch to another database half way through! (very unlikely ... so just belt & braces)Check for USEAdd the SET NOCOUNT ON at the topConnect to the appropriate, empty / new, databaseExecute the script If Fasthosts have treated you badly maybe you should be looking elsewhere. I can ask our people who they recommend in the UK if you like (the folk we use only deal with resellers / large players, AFAIK) |
|
|
|
nathonjones
Starting Member
15 Posts |
Posted - 2010-11-12 : 13:01:55
|
Well, the script ran but no tables were created.  Yet, it seemed to take a long time to execute so it must have been doing something.Any ideas what we might be doing wrong?ThanksNath |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
nathonjones
Starting Member
15 Posts |
Posted - 2010-11-12 : 13:35:13
|
Hi Tara.  I was scratching my head for a bit before I realised I needed to Refresh the object. Still no tables though.I did notice some errors during the process relating to not having permissions for "master", if that helps shed some light on matters.I couldn't find the USE command that Kristen suggested.Nath. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
nathonjones
Starting Member
15 Posts |
|
|
nathonjones
Starting Member
15 Posts |
Posted - 2010-11-12 : 14:11:57
|
quote:
Originally posted by X002548
ran...in...master.... nathon, what's the name of your database?and you might want to contract out a dbaBrett8-)
I have no idea what that means!  |
|
|
|
nathonjones
Starting Member
15 Posts |
Posted - 2010-11-12 : 14:44:52
|
quote:
Originally posted by tkizer
It seems that your script ran in the master database and not in your user database. Use the dropdown database list to select your database or use the USE command as Kristen suggested:USE YourDbNameGoesHereGO...Your Script goes here...Tara Kizer
BINGO! Thank you Tara. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-11-13 : 05:01:11
|
Nope. I said to check if there were any USE DatabaseName commands in the script that might change to an (unanticipated) database.If was you who said to specifically USE the required database. Pat yourself on the back!And that still leaves the fact that the original script ran somewhere, perhaps in the MASTER database, and 70MB of script have been run in that database, and need cleaning up now  |
|
|
|
|
|
|
Restoring an SQL (.sql) text file?
Tara Kizer