6
votes
1answer
63 views

Copy SQL Server Databases

I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB. I've seen and even used some of the various data ...
0
votes
1answer
647 views

How to undo assigning ownership of db_datareader/db_datawriter schema?

i meant to assign an SQL Server login to the db_datareader db_datawriter database roles. But if a moment of sore tummy and tiredness, i accidentally give that user schema ownership of them ...
0
votes
1answer
158 views

How was the MSSQL Server database erased in the production server (that is a different version? )

I'm asking for help understanding what happened in my situation or what and if I did something wrong. I have production server running on a Windows 2003 server with MSSQL Express 2005 with an app ...
1
vote
1answer
90 views

Does MS SQL 2005 encryption protect data in the case of physical server access?

I am looking into MS SQL 2005 encryption (not 2008, so TDE is out), and I believe I understand the concept of how a column is encrypted. The OS uses the service credentials to encrypt the service ...
0
votes
3answers
511 views

Restoring a backup SQL Server 2005 where is the data stored?

I have two Sql Server database instances on two different machines across the network. Lets call these servers A and B. Due to some infrastructural issues, I had to make a complete backup of the ...
3
votes
3answers
3k views

Shrink SQL Server data file, but not all at once?

I have a database file that's currently 150GB, but only 75GB is being used - it's because I moved all the indexes (the other 75GB) to a new data file. I'd like to reclaim at least part of the space ...
1
vote
1answer
371 views

SQL 2005 change IP address and subnet

I have to move few sql servers to a new subnet ( change IP address and mask only ), need to know what should be best practice or correct way of doing this? the sql servers are not in cluster. Thank ...
0
votes
2answers
513 views

Options to handle corrupt msdb ldf file

Specs: We're using SQL Server 2005 with transactional replication. Our MSDB .LDF file has recently become corrupted, causing the MSDB db to be marked as 'suspect'. We read a bunch of stuff online ...
0
votes
1answer
86 views

Reccomendation for tuning 100's of SQL Databases

I'm running several SQL servers, each running a few hundred multi-gig databases for customers. They are all setup homogeneously as far as the schemas are concerned, however customer usages of the ...
0
votes
1answer
296 views

Maintenance Plan Reporting - Append To File - Clean Up?

Background: (SQL Server 2005, Standard Ed.) I have a maintenance plan running backups, taking a full backup 1/day, and t-log every 15 minutes. I have it set to create a text file report of each run, ...
2
votes
2answers
1k views

SQL Server 2005: Rename DB Server Instance Name?

Can somebody tell me how to rename the DB server instance name and a DB name in SQL Server 2005? Right Now I Have SERVER/OLDNAME -- oldnameDB I want to change the server instance and also change ...
1
vote
3answers
574 views

SQL Server 2000 need to prevent logons whilst performing a backup for a side by side migration

I'm looking for a way to prevent logons from occurring in order to take a full backup of a Database to migrate from its current SQL Server 2000 instance to a new SQL 2005 instance. A friend of mine ...
6
votes
2answers
109 views

What are the basic tasks that need to be done to keep an SQL Server 2005 database healthy

I have a SQL Server 2005 database that is large in every sense. It is complex, it has a lot of data (relatively, but given the lack of blobs, it is still quite large) and it is heavily accessed. What ...
0
votes
1answer
964 views

How to DENY access for a particular database for login “sa” and grant access for another login? (SQL Server 2005 Express)

I have the SQL Server 2005 Express edition with "Mixed Mode authentication". So I want to create a database called "ActivityLogs" where I want to DENY access for the "sa" login. I want to create ...
0
votes
1answer
423 views

SQL SERVER Express Connection String for User Instances same on SQL Server Standard

So SQL Server 2005 Express edition has the following connection string by default, which enables user instances instead of Concurrrent Multi-User Access: Data Source=.\SQLExpress; ...
0
votes
2answers
5k views

How to change the default instance of SQL Server?

we have a dev server. First we had SQL 2000 (default instance), when SQL 2005 came out, we installed it as a named instance. Nowadays we barely use the SQL2000 instance, but this is the default. We ...
3
votes
4answers
1k views

Using linked servers to query across database servers?

We have multiple MSSQL 2005 servers that contain silos of information. We want our database developers to be able to join across these silos in the most transparent and performant way possible. The ...
0
votes
2answers
4k views

Unable to back up SQL Server databases using a maintenance plan

I am trying to create a maintenance plan that will run automatically and back up my SQL Server 2005 databases automatically. I create a new maintenance plan and add a "Back Up Database Task", select ...
1
vote
3answers
72 views

Normal database changes into a snapshot database when server is rebooted

This subject is a little bit outside of my experience, but we are trying to upgrade our server. We have a new machine, but are using the same versions of the servers on it (MS Server 2003, and SQL ...
1
vote
1answer
992 views

SQLVDI error - attempt to release mutex not owned by caller

I've started getting some errors in the App event log of one of our database servers (Windows 2003 & SQL Server 2005). The nightly full database backups are completing successfully however ...
6
votes
4answers
17k views

SQL Server 2Kx: How to move a database to a different partition in the local file system?

SQL Server creates its databases in the system program files directory structure. I want to separate the database files away from the system partition. Assuming the database is already created and ...