Search results for query: *

Thanks for the reply. I did read KB892429 and our cluster nodes are using a supported configuration for SMS. Also, After some checking I've discovered another SMS site of ours, where the cluster nodes are being discovered through ADSGD and being added to the custom collections for their OU. So...

We are using SMS 2003 SP1 It seems that ADSGD is not working for our cluster nodes that are running the SMS client. Our cluster nodes are all in their own OU. All other servers in separate OU's at the same level in AD are being 'discovered' but not the cluster nodes. The cluster nodes appear...

OK, I now tried starting the SQL Server Service form the 'Services' GUI in Windows, using the parameters -c and -m. Now I am able to open Management Studio. When I right-click on the master database and choose 'Tasks-Restore-Database' master is not in the list of databases to restore. I tried...

I've tried starting SQL from the command line in single user mode (-m). When I try to open Management Studio I receive an error that it can't connect. Can you only restore master from a command line in SQL 2005? Or can I do it from a GUI? Thanks, Mark

Thanks for the quick reply Denis. Should I run this "sp_dbcmptlevel 'DatabaseName',90" for each of the system and user databases? Thanks, Mark

I ran the SQL 2005 setup on my SQL 2000 server. Now all the system and user databases are set to compatibilty mode 80 and in the options tab there is no compatibilty mode 90 option. How can I set the databasbes to compatibility mode 90? Also, SQL 2000 is still running and I'm still able to...

As I stated earlier, the databases are using the simple recovery method. So, the transaction log gets truncated with each nightly backup.

Thanks for pointing me in the right direction guys. I will keep investigating.

I have a SQL 2000 server that had the tempdb database grow to over 240GB until it totally filled the drive. I'm trying to track down why this happened. There were 5 SQL jobs that ran at about the same time the SQL server log reported that templog.ldf...error112...not enough space on disk. 2 of...