Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
peaceinvt
Starting Member
1 Post |
 Posted - 2011-09-04 : 22:18:34
|
Hello -I have a point of sale server computer and 4 terminals downstairs. The server touchscreen all in one computer lost its video and I can't even get video when I hook up another monitor. the POS program is running and the database is in sql.The terminals downstairs connect to the local network and run the database as clients from the upstairs server.I need to replace the computer, but can not get my database backed up first as I can't see anything. When I try to back up from a downstairs computer (the clients all see the databse upstairs) I am told that I have to close the program. I close the POS software, but I have to shut down the sql service - again, something I can not do because I can't see anything.Can anyone tell me if there is another way to back up this database? I know nothing about sql, but I know my way around a computer (esp when I can see the screen!). thanks so much! Peace. Michele |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-09-04 : 22:44:39
|
How do you backup the database ?You can perform the backup on line with clients application connected to it using the "BACKUP DATABASE" command or via the SQL Server Management Studio. You don't even have to shut down the SQL Services.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
backup pos database with no video