Posted by: xcopsgen May 9, 2009
Login in to Rate this Post:
0 
? 
?
1. First stop the SQL server Service that is running on local. you are trying to copy from local to server right..
2. Copy the back up file that is stores in your C: Drive some where in MSSQL.1\......bak file to some other location. Remember to copy it not move it.
3. You can start the service.....
4. Create new database.
5. You can restore that backup file to do that create a new database with the same name. Restore the back up file.
6. Remember to stop local SQL server.
Happy SQL Programming. If you have further problems.......email me....
Austin - Texan....
2. Copy the back up file that is stores in your C: Drive some where in MSSQL.1\......bak file to some other location. Remember to copy it not move it.
3. You can start the service.....
4. Create new database.
5. You can restore that backup file to do that create a new database with the same name. Restore the back up file.
6. Remember to stop local SQL server.
Happy SQL Programming. If you have further problems.......email me....
Austin - Texan....