Setting up SQL 2005

[Zen2]

Hey,


Maybe a mod / admin could make this thread a sticky for noobs,

Well i was new to sql but withing a day or 2 i am nearly a proffessional at useing it! I had many of problems that no one on here could seem to really help me solve, So i did abit of research and came across this website that basicly shew me, Step by step in vidio form how to use MS SQL 2005 Express. I am most impressed with this website supplying these vidios for free! hopefully this thread will help some new people with SQL!

Heres the website! check it out

http://msdn2.microsoft.com/en-us/express/aa718391.aspx#4


Good luck! (not that you will need it punk: )

 

[jasper]

right click databases
restore database
in the "to database" put lom2 or mir2, (whatever you put here needs to match the info in !setup and dbsrv inis)
select "from device"
click the browse box ...
click add
(wait a second or 2)
when the browser window opens, select show all file types
locate c:\mirserver\dbserver\mir2(restore this)
click ok
click ok
select the tick box under restore
click ok (and wait)
should say
"the restore of database (whatever you named it earlier)completed successfully)
to check, expand the database icon, you should see the db there

 

[Zen2]

Delete this post please!

 

[Zen2]

Delete this post please!!

 

[Elvin]

Delete this post please!!

go on why not do as he asks :P
not looked at the vid but i set up 05 fine for tds files and im a 40 yr old nub at anything electronic...