0
votes
2answers
45 views

How do I connect to some local DB server in MS SQL Server 2012?

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
0
votes
2answers
47 views

What are the risks of copying MDF/LDF files without detaching the DB first?

Our support team have been trained to restore databases by stopping the instance service and then copying a backup of the LDF and MDF files into the folder. All without detaching or attaching the DB ...
2
votes
1answer
727 views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
2
votes
1answer
3k views

How Do I Investigate a CPU Usage Spike Without Being Present?

I have a server that's mysteriously using up a lot of CPU late at night, when it shouldn't be under heavy load. This causes some database calls to time out, and I've set up some alerts in PerfMon to ...