Viewing 15 posts - 151 through 165 (of 1,157 total)
What is the operating system?
Please post the complete error message.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
January 2, 2011 at 9:34 pm
To add to what Gethyn had already explained, you can find the Process ID of SQL server in SQL Server Error Log.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
January 2, 2011 at 9:31 pm
Recreating the Clustered Index on the new file group will move the table as well.
CREATE CLUSTERED INDEX ..... ON [newfilegroupname]
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
January 1, 2011 at 9:59 am
Hi Ankur,
I am not making use of any scripts to get the details of the Cluster. Since there will be hardly any changes in Cluster configuration, we usually refer the...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 31, 2010 at 5:48 am
Check if the login has View Server State or above permissions on the instance.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 31, 2010 at 12:27 am
As Jo suggested, check if the SQL Server Agent service account has FULL permissions on the network share.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 31, 2010 at 12:24 am
Did you try granting Users full permissions on C:\Program Files\Microsoft SQL Server\90\Shared folder as mentioned by Brett G here?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 31, 2010 at 12:15 am
Please confirm if the SQL Server Agent service account has "sysadmin" privileges on the instance.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 30, 2010 at 11:50 pm
Powershell offers good flexibility. Here[/url] is a nice example.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 30, 2010 at 11:41 pm
This article has the details.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 30, 2010 at 12:34 pm
I concur with Gail. There is serious issue with the underlying storage. Please involve the storage vendor to look into this.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 30, 2010 at 12:19 pm
The best option would be to restore the database from good backups
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 30, 2010 at 11:47 am
During that time, you see any errors in System Event Log?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 30, 2010 at 9:53 am
Even I had come across a similar issue. You need to "select" the domain for the first text box and then copy/paste it to the next two fields. I had...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 30, 2010 at 9:42 am
What is the error message that you receive?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 30, 2010 at 9:39 am
Viewing 15 posts - 151 through 165 (of 1,157 total)