| Thread | Last Post | Replies |
|
| cleaning up backups | 03 Mar 2008 19:26 GMT | 2 |
I recently took responsibility for a sharepoint 2003 server & corresponding SQL 2000 server. The backups are working through a maintenance plan, but I'd like to implement a richer plan and am having difficulties developing the best approach. understand I've not done much care & ...
|
| the effect of huge amounts of RAM? DB cache? | 03 Mar 2008 19:22 GMT | 10 |
I have tons of short SPs being called all the time. The # of milliseconds on each matters and I'm at a point where pulling data from the hard drive slows down the operation more than anything. I've done tuning, etc. So if I get more RAM on a SQL Server 2005 than the size of ...
|
| SCREWY LAST BATCH DATE | 03 Mar 2008 18:09 GMT | 1 |
Using SQL2k EE SP3 There's a spid in the activity monitor that has a Last Batch date of 1/1/1900 12:00AM however, the logged In date is recent. What could cause this to happen?
|
| SqlServer 2000 DB Restore - User Does not have a Login Name | 03 Mar 2008 16:32 GMT | 2 |
A system that houses an app and it's database was restored. The database called testdb has a user called testdbuser. When I check the users for this db - it shows testdbuser - the properties show the Login Name as <none> after the restore.
|
| Error 3409 when trying to link to SQL Server table | 03 Mar 2008 16:04 GMT | 3 |
We are using SQL Server 2000 (latest SP) on Windows Server 2003. Recently we made database changes where we deleted a number of columns from the highest level table in our database hierarchy (every other table is either a child or grandchild of this table).
|
| Database backup issue - Space requirements | 03 Mar 2008 14:47 GMT | 13 |
I am trying to figure out how disk space is used when overwriting backup files. Here is a description of our situation... We have a 700+GB reporting database (SQL 2000) that we backup weekly to a 1 TB drive. This has worked fine for quite a while but we have seen the
|
| SQL 2000 on Windows Server 2003 with Sp2 | 03 Mar 2008 13:30 GMT | 1 |
I have: One server with Win2003 Sp1 and SQL 2000 Sp4. Are there any known problems with applying Windows Server Servicepack 2? I currently have problems and needs to If this can be a problem based on known issues that IM NOT aware of.
|
| importing data from access to sql 2005 nightly | 03 Mar 2008 12:38 GMT | 2 |
I hope I am giving the right information here to get help with this. I am trying to get information from two tables that are in an access database over to sql 2005. I did this via DTS and saved the import options as a file, but when I run this as a job I get the following error: ...
|
| SQL2005 linked server changes in SP2 | 03 Mar 2008 10:31 GMT | 4 |
We have an OLEDB provider written using C++ and the OLEDB templates. It works fine under SQL2000 and SQL2005 SP1 but in SP2 we get the following error OLE DB provider 'CAMEOProv2.CAMEOProv' cannot be used for distributed
|
| SQL 2005 SP2 won't install on new node of 3-node SQL Cluster | 03 Mar 2008 08:16 GMT | 3 |
I've just received a new machine to add to my 3-node SQL Cluster on which 2 instances were installed. I've only installed one of the two instances on the new server because the second instance will surely dissappear.
|
| resetting @@FETCH_STATUS | 03 Mar 2008 01:37 GMT | 2 |
I'm using two cursors in the same proc. Do I need to reset @@FETCH_STATUS before using it to check the status of the second cursor? If so, how can this be done. Many thanks for your answers in advance
|
| Lost TLOG drive. Help restoring using just mdf files. Trying sp_attach_single_file_db... | 02 Mar 2008 20:05 GMT | 6 |
Morning everybody, I'd appreciate if anybody could give any help with problems getting databases back online when i just have the .mdf file I lost the TLOG virtual drive yesterday (had a fatal problem with the
|
| Maintenance Plans | 02 Mar 2008 16:10 GMT | 4 |
We just started using DPM 2007 to backup our 2005 DB's so I am deleting the backups in the maintenance plans. Should I go back in and have any regular maintenance on DB's like Shrink or Reorganize or is just backing up using DPM ok?
|
| Bad Logs | 02 Mar 2008 11:42 GMT | 9 |
Let me correct that. The data part of the database is also corrupt. Is there a way to delete the corrupted part of the data base and try a partial recovery?
|
| SQL Server Express going to sleep | 02 Mar 2008 07:47 GMT | 1 |
I'm a developer using SQL Server Express to a vb.net application. On regular occasions I get a query that normally returns in less than a second, timeout (90secs). Searching forums I noticed a lot of other people of the same issue, but without resolve. People mentioned the ...
|