Copying SQL Server DB to CD
Discussion
I need to copy a SQL Server database to a CD and was wondering how the hell I do it as i've looked around but can't find a way of doing it.
I'm using SQL Server 2005 and SQL Server Management Studio Express, and the DB isn't particularly large or complicated. Do any of you know a way to do this?
Cheers
Mike
I'm using SQL Server 2005 and SQL Server Management Studio Express, and the DB isn't particularly large or complicated. Do any of you know a way to do this?
Cheers
Mike
I am complete ING TWAT. Being the idiot that I am and without thinking I thought DROP DB TO or whatever it says would to the trick, so dropped it to a folder in My Documents. I've now deleted the database and I can't connect to AGETHA (my computer) because the default DB is not longer there.
Is there a way to undo this or recover it? I have what ever file I created in the folder I sent it to but have no idea what it is for. This is for my final year university project and I have to demonstrate my work in a week .
Is there a way to undo this or recover it? I have what ever file I created in the folder I sent it to but have no idea what it is for. This is for my final year university project and I have to demonstrate my work in a week .
It's just called RF_Medi_ID_2.sql. Just spoke to a friend and apparently the database will be pretty much completely gone now. Oh well, I have a week to re-create the DB and Stored Procedures and make sure every file name matches up with the file names in my code for a mobile Web Form .
This absolutely typical, it always happens right before hand-in .
This absolutely typical, it always happens right before hand-in .
SneakyNeil said:
That was unfortunate.
Yea it was a bit . Could have been worse though, I could have lost all my written work the day before deadline. At least I only have to go about re-creating a database which doesn't require much of an artistic license when you have the designs. And I have a week before I have to display my product anway.
Cheers spiccy I may as well try that undelete product. Fingers crossed eh.
Yeah not knowing what DROP FROM DATABASE means is pretty bloody stupid, but I click before thinking. I know DROP TABLE and that but just wasn't thinking. I'm already laughing about it though. In between the bitter resentment of my own stupidity .
BlairOut it was trying to create a backup that caused me to delete it (hows that for sounding like an idiot), and the only part of my project I hadn't previously backed up (the other work was backed up religously on several different media).
Judas, the script it created was the SQL Query to delete the database, which I did execute about 30 seconds before my housemate phoned me back and told me DROP means delete .
It's OK though, i've had a nice pint of Cruzcampo and am back at work to fix this bloody error with the database which is causing me to not to be able to create a new database. It never rains, it only pours .
BlairOut it was trying to create a backup that caused me to delete it (hows that for sounding like an idiot), and the only part of my project I hadn't previously backed up (the other work was backed up religously on several different media).
Judas, the script it created was the SQL Query to delete the database, which I did execute about 30 seconds before my housemate phoned me back and told me DROP means delete .
It's OK though, i've had a nice pint of Cruzcampo and am back at work to fix this bloody error with the database which is causing me to not to be able to create a new database. It never rains, it only pours .
mikey_p said:
Yeah not knowing what DROP FROM DATABASE means is pretty bloody stupid, but I click before thinking. I know DROP TABLE and that but just wasn't thinking. I'm already laughing about it though. In between the bitter resentment of my own stupidity .
BlairOut it was trying to create a backup that caused me to delete it (hows that for sounding like an idiot), and the only part of my project I hadn't previously backed up (the other work was backed up religously on several different media).
Judas, the script it created was the SQL Query to delete the database, which I did execute about 30 seconds before my housemate phoned me back and told me DROP means delete .
It's OK though, i've had a nice pint of Cruzcampo and am back at work to fix this bloody error with the database which is causing me to not to be able to create a new database. It never rains, it only pours .
BlairOut it was trying to create a backup that caused me to delete it (hows that for sounding like an idiot), and the only part of my project I hadn't previously backed up (the other work was backed up religously on several different media).
Judas, the script it created was the SQL Query to delete the database, which I did execute about 30 seconds before my housemate phoned me back and told me DROP means delete .
It's OK though, i've had a nice pint of Cruzcampo and am back at work to fix this bloody error with the database which is causing me to not to be able to create a new database. It never rains, it only pours .
don't laugh - one of our remote support teams in Mumbai was trying to clear a databases' users and accidently deleted the system logins - he then logged out of the system and wondered why no one could login again........
To compound the matter even more, the same person then decided to rebuild the master database. When he then logged in there were still no user logins (there wouldn't be any by default) and now there were no user databases - thankfully we don't let them loose on our Production systems.......
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff