Viewing 15 posts - 4,951 through 4,965 (of 6,676 total)
You are welcome - glad I could help.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 24, 2009 at 2:53 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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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....
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 24, 2009 at 2:18 pm
SanjayAttray (6/24/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
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...).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 24, 2009 at 1:30 pm
This is generally caused by having a lower version of the client tools accessing a higher version of the database. For example, your client tools are probably at RTM...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 22, 2009 at 8:24 pm
I find this section the most interesting:
06/09/2009 10:18:50,spid94,Unknown,***Stack Dump being sent to R:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0376.txt
06/09/2009 10:18:50,spid94,Unknown,**Dump thread - spid = 94 PSS = 0x51F2B5E0 EC = 0x51F2B5E8
06/09/2009 10:18:50,spid94,Unknown,Using...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 22, 2009 at 8:19 pm
There is a very good article on this site about setting up Kerberos. Here are a few of my thoughts on your issue:
1) Running as sysadmin does not guarantee...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 22, 2009 at 8:09 pm
Viewing 15 posts - 4,951 through 4,965 (of 6,676 total)