New answers tagged

0

You're saying that you saw print drivers for random printers - those drivers are usually installed by the server itself if you are connecting with RDP and have print redirection enabled (and Remote Desktop Easy Print fails to map the printer). If you are the only one who use RDP to this server and you don't recognize any of the print drivers then I'm pretty ...


0

This indicates an ungraceful shutdown. i.e. the node was shot in the head using a software power switch. Something to contact MS about. Log Name: System Source: Microsoft-Windows-Kernel-Power Event ID: 41 Level: Critical Description: The system has rebooted without cleanly shutting down first. This error could be caused if the system ...


3

Your best bet is to copy the mdf and ldf files to another location. Then uninstall the 2012 version, install the 2014 version. Then you just need to drop your mdf and ldf files into the DATA directory and then browse to the Database node in SSMS, right click then select Attach... It will pop up a dialog. Point it to your mdf and ldf files and you should be ...


0

I don't think there's any mystery to this - you need a license for 2012 version - certainly you can't upgrade unlicensed software


3

The VM has it's private addresses translated to a publicly routable IP address at the network boundary - this is called network address translation. when you assign a public IP to an instance in the cloud what you are really doing is setting up a NAT rule. Inside the VM you continue to work and configure software as you would on a private network, so if your ...


1

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.


3

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 ...


0

the first thing I would do is actually verify if you have the right password there, as the message says. if that is not the case, then I would as a rule create a proxy to run any packages from inside sql server. make sure that the right permissions are also granted in any folders/files/databases/servers that the package needs to access/read/modify I have ...


2

RDS has recently added a stored procedure to accomplish this: EXEC rdsadmin.dbo.rds_modify_db_name N'<OldName>', N'<NewName>' source: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.html#Appendix.SQLServer.CommonDBATasks.RenamingDB


2

Execution plans: OBVIOUSLY. As does restarting the server - these are kept in memory and generated on demand. Which also means you never collected them over the years. Unless you have a never patched system which would be a much bigger problem. Statistics: no, those are actually objects in the database, so they transfer. Here you also did NOT collect them ...


0

Try Free SQL LDF File Viewer which allow you to read and analyze SQL Server Transaction logs.


0

I got the same error but It was due to privileges.Once I have given with all privileges on drive i.e. Windows Drive , Its working without any error.


1

This isn't really an Azure question, its a "how do I do SQL clustering question". You can't just share a SQL database between two VM's and it magically work, you would need to setup your VM's in a cluster to share the SQL workload between them. Clustering in Azure is slightly different than on premises as you can't use shared disk storage for clustering ...


0

LGTM. However, keep in mind that any permissions granted to the public role will also be granted to this user. So if it would be a serious violation to have this user gain access to the base table (or other objects in the db), you'll need to audit this periodically.


0

When both the web server and SQL Server reside on the same machine, by default shared memory is used for the protocol. If you move the SQL Server to another box the communication has to go via TCP/IP. Basically when using shared memory the client application can read tabular data streams (TDS) directly from SQL Server's memory. When using the TCP/IP ...


0

The last two things I can think of is to check of you have the MSSQLSvc SPNs registered under the SQL server service account registered (which you may have already since you have a working scenario). Just in case: MSSQLSvc\NetBIOS MSSQLSvc\NetBIOS:1433 MSSQLSvc\FQDN.domain.com MSSQLSvc\FQDN.domain.com:1433 If that is done, then going back to the AD tab ...


0

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