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 |
|
j9_ls1
Starting Member
2 Posts |
 Posted - 2011-01-17 : 12:02:24
|
| hey guys, Im new to this forum but I had a few questions. Over the past 2-3 months, our SQL database seems to be inaccessible. It is online/mounted, and it can be queried in SQL. However, on our GUI, its reporting errors. I dont think this is coding, since nothing has changed. What seems to work is if I kick off a backup within SQL. Once the SQL backup is done, then the database is accessible again. Im not sure what the backup could be doing that causes it to work, and I have tried to find the white papers on the backup policy, but I was unsuccessful. Do you all have any ideas for me?thanks |
|
|
j9_ls1
Starting Member
2 Posts |
Posted - 2011-01-17 : 12:04:01
|
| FYI here are my specs:Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-17 : 15:02:33
|
| What are the exact error messages you're getting?What do you see in the event logs and SQL Server logs? |
|
|
|
|
|
|
SQL database problems, and restore issues