Viewing 15 posts - 4,951 through 4,965 (of 6,679 total)
Run the following query:
SELECT Name, recovery_model_desc, log_reuse_wait_desc
FROM sys.databases
Find your database and see what SQL Server is reporting for why the log cannot be reused. This will also...
June 24, 2009 at 3:24 pm
arctica82 (6/24/2009)
Sorry, I am a little bit confused.So,can I install SQL SERVER 2008(Database Engine+Client tools) on local drive of one of nodes without creating any problem for Clustered environment.
Yes -...
June 24, 2009 at 3:05 pm
Verify when the snapshot is occurring and double-check to make sure there are no other processes running at the same time.
June 24, 2009 at 2:56 pm
Okay, since this was a cancelled restore you should be able to right-click the restoring database and delete it. Once deleted, you can then delete the mdf/ldf files if...
June 24, 2009 at 2:33 pm
Data files for databases tend to grow - why are you worried about recovering the disk space? The next time you reindex/reorg the data file is just going to...
June 24, 2009 at 2:25 pm
I would also question why you are moving to SQL Server 2000. You really should be moving to 2008 since that is the most current version of SQL Server....
June 24, 2009 at 2:20 pm
arctica82 (6/24/2009)
What about Local drive of one of the nodes?
You can install a separate instance locally on that node - yes. The question really then is why are you...
June 24, 2009 at 2:18 pm
SanjayAttray (6/24/2009)
June 24, 2009 at 2:16 pm
You have asked several questions, and I bet nobody here really understands what problems you are actually having.
For example, I have no idea what problem you are having with database...
June 24, 2009 at 1:53 pm
No, you cannot use any existing drives as those existing drives have been setup as resources in the cluster group where that instance of SQL Server also exists.
Think of it...
June 24, 2009 at 1:50 pm
Looking at the logic you have here, it appears to me that you are appending the differential backup to the last full backup.
Since each differential backup would add to the...
June 24, 2009 at 1:47 pm
Before you do that - have you refreshed the information in Object Explorer? Or, just closed SSMS and re-opened it?
June 24, 2009 at 1:38 pm
It would be much easier if you did not use a single device to contain multiple backups. You should be setting it up to backup to a specific folder...
June 24, 2009 at 1:34 pm
Yes, you can add a new clustered instance running SQL Server 2008. But, the new instance is going to require new cluster resources (separate drives, IP address/name, etc...).
June 24, 2009 at 1:30 pm
Viewing 15 posts - 4,951 through 4,965 (of 6,679 total)