Viewing 15 posts - 1,096 through 1,110 (of 1,157 total)
See this MS KB article.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 2, 2009 at 1:10 am
You may find this link useful.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 1, 2009 at 11:27 pm
I think this snip should help you.
SELECT A.NAME,B.TOTAL_ELAPSED_TIME/60000 AS [Running Time],
B.ESTIMATED_COMPLETION_TIME/60000 AS [Remaining],
B.PERCENT_COMPLETE as [%],(SELECT TEXT FROM sys.dm_exec_sql_text(B.SQL_HANDLE))AS COMMAND FROM
MASTER..SYSDATABASES A, sys.dm_exec_requests B
WHERE A.DBID=B.DATABASE_ID AND B.COMMAND LIKE '%RESTORE%'
order...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 1, 2009 at 11:24 pm
Hi Art,
You may want to check the Service Principal Name (SPN) for the service account. More information about SPNs is available here
SetSPN utility can be downloaded from here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 27, 2009 at 8:54 pm
Art,
Please check whether "BUILTIN\Administrators" have access to the SQL Server and also try adding the user again as below.
Grant [domain\user]
EXEC sp_grantlogin [domain\user]
--Add that account to the sysadmins role:
EXEC sp_addsrvrolemember @loginame...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 26, 2009 at 11:43 pm
Jeff Moden (2/26/2009)
Can't use -E from a command prompt... only from SQL Server.
I disagree with this. I have tried using -E (Trusted connection) and it works well from...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 26, 2009 at 11:33 pm
To stop and start SQL Services, the user must belong to the "System Administrators" group. Is your SQL login part of that group?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 26, 2009 at 11:06 pm
Which Edition of SQL Server are you using and what is the Operating system?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 26, 2009 at 10:58 pm
You can also try executing DOS commands using xp_cmdshell
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 26, 2009 at 10:15 pm
I am not sure about the option to "Enable/Disable" debugging on all queries. I doubt this could also be one of the reason.
The shortcut for debugging is "Alt + F5"
We...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 26, 2009 at 10:10 pm
Please try using the "Server Name" or the "IP Address" instead of "localhost".
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 26, 2009 at 10:04 pm
There are various methods of doing this. One of them is explained in this KB
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 26, 2009 at 4:38 am
Hi Robert,
You have used the correct commands to verify the backup integrity. From the error message, it looks like the backup file is corrupt.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 26, 2009 at 4:20 am
ashok.nayak1 (2/26/2009)
Hi All.....what is minimum database require to start the SQL serevr database???
Did you mean minimum databases required to start SQL Server service? If so, then the following system databases...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 26, 2009 at 3:41 am
Little bit of Googling will surely help. However see this link.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 26, 2009 at 2:59 am
Viewing 15 posts - 1,096 through 1,110 (of 1,157 total)