Hello Masters,

Thanks for your views.

1. No this database is not replicating.

2. We are not concern which transactions hitting more records.

3. We need solution to overcome disk space crunch instead of...

Thanks GilaMonster!

I will try this strategy. 🙂

But there could be something through which we can have approximate time value ?

Thanks GilaMonster,

I will try to restore log file with given strategy.

How to do that ?

Using Command prompt ?

Click the Start button.

Type "command" in the search box... DO NOT hit ENTER yet!

While holding CTRL-Shift on your keyboard, hit ENTER.

You will be...

Hello Gila Monster,

Hello Grant Fritchey,

Hello Other masters..

Can you please look into this issue ?

Its very much urgent for me 🙁

Hello Masters,

Thanks a lot for the Suggestions !

After discussing all the possibilities, we decided to create new cluster instead of installing 2014 on existing 2008 cluster. Its fine for now,...

Hello Perry,

Current cluster is with SQL server 2008 Enterprise Edition with latest service pack, OS is Windows server 2008.

Now we want to install SQL server 2014 on the same cluster....

Hello Gila Monster,

It seems some issue with Backup set only. I ran below query on MSDB:

SELECT

'SQL' + '_' + msdb.dbo.backupset.machine_name+'_'+ convert(CHAR(30),SERVERPROPERTY('Servername')) +...

Hello Gila Monster,

I checked MSDB, there is nothing mssing with backup set.

Is it any bug with SQL 2012 Management studio ?

Go to services and checked the correct instance name. and try that instance name to connect to instance.

OR

Just try server name to connect to instance (In case of default instance)

OR...

Hello Guys, I am able to do that.

One more query here, during import\export wizard, i seen one more option "Save as SSIS Package".

Is it saving those export file job...

Thanks all of you for your feedback and information.

I agree with all of you and will try to investigate more on "What causes more CPU usage to my SQL Server...

Thanks again Perrry !

I will read your article today.

Now we got confirmation that we would get OS as Windows server 2008, Wintel team started installation. 🙂

Thanks bunch Perry !!!

I informed it to delivery team and who agreed client to have OS as at least Windows 2008.

Still my question is unanswered :crying:

How we can install multiple...