Saturday, March 23, 2013

[MS SQL Server] Add data file in mirroring

[MS SQL Server] Add data file in mirroring


Add data file in mirroring

Posted: 22 Mar 2013 11:02 PM PDT

Here i have configured the mirroring. after that i want to add the data file to primary.can we add the data file?if we add is there any impact on mirror server and those data file will be add in mirror server orhere both principal and mirror are in synchronization mode.same is it possible to add in log shipping also. is there any impact on it.please provide the procedure.

doubt on backups

Posted: 22 Mar 2013 10:35 PM PDT

Hi allHere we are having 100 databases ,for 30 databases are backed up in first shift they are not prepared the document.i cam on second shift how can i know which database is backed up and which is not.As per my knowledge we can use the restore header onlyis there any other option for thisThanks in advance.

How do I move SSAS cubes from one location to another on the same server?

Posted: 22 Mar 2013 08:19 AM PDT

SQL Server 2008 R2 64-bitI can find lots of info on migrating from one version of SSAS to another, or on moving an instance from one server to another, but I'm coming up short on definitive info on must moving the cubes from the default location in C:\Program Files\... to another volume on the same server.Is this so easy that no one needs to ask? Or, so hard that no one does it? Or, do my search skills suck? At any rate, if anyone has any pointers please pass them along.

Database Mail Disabled but SQL Server Agent Sends Out Alert Emails

Posted: 22 Mar 2013 06:05 AM PDT

Since executing sysmail_stop_sp (disabling the Mail queue) - sp_send_dbmail will stop working (as expected) but the sql agent still sends out Alert emails when I RAISERROR with Log I also disabling the Database Mail XP's in configurations and yet the Agent sends out emails.Any thoughts?Thanks

No comments:

Post a Comment

Search This Blog