1
vote
1answer
26 views

HeidiSQL, attach/register database in MSSQL server

How to attach (or register) an existing MSSQL database to a server Using HeidiSQL
2
votes
1answer
60 views

Copy a database from Denali CPT3 to SQL 2008 R2

Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a ...
1
vote
3answers
835 views

Can we restart a SQL Server instance remotely?

I am connecting to SQL server 2008 R2 from a remote machine, but when i right click on the instance in object explorer it shows me Start,Restart,Stop, Pause, Resume options disabled I am connecting ...
1
vote
2answers
351 views

SQL Server variable size and increase it

It is not clear to me how a varchar(max) is declared or used in an SQL Server e.g. 2005 Is a variable declared as varchar(300000) for example considered as a varchar(max)? E.g. I am seeing in a DB in ...
1
vote
3answers
170 views

What database backup utility should I use?

Can anyone recommend a database backup utility, free or paid? Ideally it will backup MSSQL & MySQL, but MSSQL only will suffice allow backup of single tables encrypt backups Many thanks
0
votes
2answers
302 views

What Could Be Causing MySQL To Crash On A Read Query?

So I have a pretty large MySQL DB... 7 Gigs in Total size, 35 million URLs. I was querying it (using SELECT queries only) quite fast the other day. My ubuntu froze/shutdown (that's a first!) and said ...
1
vote
1answer
1k views

What is the best way to determine what's locking up SQL Server using a query?

Recently our SQL Server is getting bogged down by something. I was wondering what is the best way to check what could be causing the problem by querying the database. This is the best I've found so ...
1
vote
2answers
247 views

SQL Server Replication Backup

We have a new system that runs on SQL Server 2008 r2 64-bit. There is a primary on-line transactional processing (OLTP) database that accepts a high volume of updates from several thousand Point of ...
4
votes
4answers
2k views

How to shape size of SQL server resorces (RAM, CPU, and others)

It is standard story, there is fight between developers and administrators. One denunciation that database design and queries are bad while others says It is lack of hardware and amount of data. So ...
1
vote
1answer
255 views

Database maintenance plan fails to run everytime

I currently setup a DBMP for SS2008 and i explicitly set it to run under a user that is the the serveradmin role. Also in the job (under sql server agent) generated from the above plan is set in the ...
1
vote
1answer
214 views

MSSQL Replace Database in Live Web App

I have a web app that is currently live. I had the need to make major modifications to the database and now I need to replace the current one. My dev SQL instance is not the live one. I usually ...