Viewing 15 posts - 1,096 through 1,110 (of 1,409 total)
It could be that the IP cluster resource is unable to determine which node of the cluster is the owner of the group. I'm not a Windows cluster administrator so...
June 12, 2013 at 6:42 am
First you will have to pin-point the location of the problem. It could be anything from the application server, the network, the database server and/or the instance.
If possible: create every...
June 12, 2013 at 6:33 am
Hi,
I understand your situation. When you only want to know the backups taken by the maintenance plan, you could query the table [msdb]..[sysmaintplan_logdetail]. This will give you a log-result of...
June 12, 2013 at 12:01 am
Drop the existing linked server and recreate it with the proper servername. Before deleting the current linked server you could first script it out (right click linked server, script linked...
June 11, 2013 at 5:36 am
GilaMonster (6/11/2013)
Someone took an ad-hoc full backup?
You can check this by restoring the header of the backups and look at (the sequence of) the LSN numbers.
Do you use compression on...
June 11, 2013 at 4:25 am
mca.deepak3335 (6/11/2013)
hi on which option should I click in object explorer like databases ,tempdatabase.
- Start SQL Server Management Studio
- connect to the instance where you want to create a view
-...
June 11, 2013 at 3:36 am
You could create a new view from SSMS. Just right click "views" in Object Explorer and choose "new view". This will open up the design view (which act as some...
June 11, 2013 at 3:12 am
Your post is very unclear. The code provided does not parse (syntax errors) and cannot be executed.
June 11, 2013 at 3:05 am
It's getting very weird. Now I also can't download the requested file (executable) anymore and get directed to SQL2012.
Try this one: http://www.microsoft.com/en-us/download/details.aspx?id=6362 (choose the 'register and download' link.)
P.S.: when I...
June 11, 2013 at 2:39 am
With the code you provided it is still not very clear. There are some typo's in it and it is not clear if the "insert into Remarks ()" line is...
June 11, 2013 at 2:04 am
Query the backup tables in the MSDB database to see a logging of all backups including the files created.
Something like:
SELECT database_name, name, physical_device_name, backup_start_date, type
FROM [msdb].[dbo].[backupmediafamily]
INNER JOIN [msdb].[dbo].[backupset] bkset
ON [backupmediafamily].media_set_id...
June 11, 2013 at 1:43 am
Joie Andrew (6/11/2013)
June 11, 2013 at 1:22 am
Take a look at http://msdn.microsoft.com/en-us/library/cc646023.aspx for the required firewall settings.
The error message "database is not accessible" seems a SQL-related error. Does your account have all the needed rights on the...
June 11, 2013 at 12:51 am
I can't help you because in our environment I have never installed SP3 on a fresh installation. But an installation will record all actions in files in the ...\setup bootstrap\log\{datetime}...
June 11, 2013 at 12:35 am
try this link:
http://www.microsoft.com/en-us/download/details.aspx?id=8158 which leads to
http://www.microsoft.com/en-us/download/confirmation.aspx?id=8158
June 11, 2013 at 12:25 am
Viewing 15 posts - 1,096 through 1,110 (of 1,409 total)