Monday, September 21, 2009

DBW624 - MS SQL2005 backup and restore

I backuped my work at school using MSSQL 2005, then I want to restore it at home.
It successed resotre tables, but not the diagram. The diagram includes all the relationship of tables. If in a big project, it will take a whole day to recreate it. How I can restore the database without losing anything?
When I click the diagram part, it said the owner of the database is not current user. So I added a user in my Vista, the username and password are the same as what I was using at my school. I still can't get back the diagram. Maybe I need to use the created user to login my vista, and restore the database.
I also gave the created use administrator permission. But in school, I don't have administrator permission, so if I have done something at home, and I backup it up, when I restore it at school, I will have the same problem again -- I will lose the diagram after I restore it because the permission of the created user are different.

WIN210 - win2003 server installation

I found win2003 can't install on external usb disk or flash disk. So I bought mobile hard disk.
I our school, I found similar computer have same hardware. For example, if the computer in lab installed a mobile hard disk, so the motherboard is the same as the one in my classroom.
I tried to put my mobile disk in lab, it works. But there is one problem, I registed my win2003 license in classroom. When I install the same mobile hard disk in lab, it ask me to regist again. I tried to regist again, Microsoft said that this license has been used multiple times. I can't use this license again. Now I have 30 days to active win2003, otherwise, my win2003 will be locked.
How to get win2003 active again? I'm going to call the Microsoft registration and ask them. Because I also need to use this mobile hard disk at home. Luckly, my home motherboard is compatible to those computer in my school, I can use win2003 at home. My idea is to use one win2003 license on a mobile hard disk in 3 locations (classroom, lab, home).

Hardware Project 1 - Diskless XP

Software: Richtech V3.0
Hardware: 1 server, 2 station
found station motherboard GE PRO-M2 doesn't support. P4VM800 and P4i65G support.
found station domain login is fake.
Question: if server full name is "xxxserver.server.abc.com", it installed active directory, what's the domain for this server? For example, when I use a station to login, I want the server's active directory to control the username and password. What's the domain I should use in order to use the Active directory? I tried "xxx.server.server.abc.com", "server.abc.com", "abc.com" all doesn't work, but I tried "server", it works. So the domian should be "server". When I relogin, if I tried to use "server" as domain, I can't login. I have to use "station00" instead of "server" to login, so why I can login use "server" as a domain at the first time, but I can't use "server" to login now.