New answers tagged sql
Just verifying: If I understand you correctly, you want to change the management studio (SSMS) interface language and leave the actual SQL Server language as it is. English is supported on all localized versions of SQL Server, so you shouldn't have to install a language pack. You might be able to use -> Tools -> Options -> Environment -> International ...
Agreed -- db mirroring would be highly unlikely in this situation since it works best if it's persistent and would need manual intervention every time you turned your desktop system on. Snapshot Replication is the only realistic option in the replication world, and there's no benefit gained over using a simple database backup and restore or AWS snapshot.
Point 2, can be addressed by using AWS RDS to back up data for you. Otherwise, you manually need to create a snapshot of your EC2 instance but this involved a tiny bit of downtime and will cost money to store on S3. Point 1, just restore the database Either way, you want a high level of functionality that you don't want to pay for, so our options for ...
For the DNS name for your site, Azure Traffic Manager is what you need to have Azure fail over to a second location automatically in the event of a data center failure. You can configure traffic manager to either load balance between the regions in an Active/Active configuration or to fail over in an Active/Passive configuration With your database URL it ...
You could also add back the "mysql" user either with adduser command or by editing the files /etc/passwd, /etc/shadow and /etc/group. You can have the previous ids of the user and group from the legacy "mysql" files
I'd reinstall mysql package. Re-installing the package does not delete your data (Source), so I'd do the following: Backup mysql data folder using cp -ar /var/lib/mysql /safeplace Remove the package: apt-get remove mysql-server Reinstall the package apt-get install mysql-server
I would imagine that you are running this in master.. the sys.dm_db_index_physical_stats reports at global level, the other tables are at a database level. you can confirm this by USE and executing you should see data returned. You may also want to use sp_msforeachDB ( http://weblogs.sqlteam.com/joew/archive/2008/08/27/60700.aspx) to execute the code in ...
Top 50 recent answers are included