6
votes
1answer
59 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 ...
1
vote
1answer
300 views

dbcc checkdb('XYZ', REPAIR_ALLOW_DATA_LOSS) indicating that XYZ is already open and can only have one user at a time

I have a DB, XYZ, that had a corrupt log file and now since the log file is totally unusable this is rendering this specific DB unusable and I need to be able to rebuild it. I've already done a lot ...
0
votes
2answers
337 views

SQL Server 2008 - Backup Databases with more than 50 characters

I am using T-SQL to backup my MS SQL 2008 databases: BACKUP DATABASE @name TO DISK = @fileName The problem occurs when it comes to the databases with their name length greater than 50 characters ...
2
votes
1answer
869 views

How can I create a database backup replacing the previously created backup file?

If I backup my SQL Server 2008 R2 database with the following command set @BackupFileName = N'C:\backup\Production-db.BAK' BACKUP DATABASE [Production-db] TO DISK = @BackupFileName and run the ...
4
votes
1answer
155 views

What is the best way to replicate a large number of SQL 2008 DBs to a failover instance in Amazon Web Services

Our application creates a new sql database for every customer and we will be continually adding new customers and creating new databases every day. These databases can range in size from 3 megabytes ...
1
vote
3answers
200 views

T-SQL query to schedule the back-up by using Transactional logs!sql server 2008

Hello i am new to sql server and i don't know any thing about backing up database using tsql i am trying to find out the procedure to do following but unsuccessful. T-SQL query to schedule the ...
1
vote
1answer
690 views

SQLS Timeouts - High Reads in Profiler

I've audited a SQLS2008 server with Profiler for one day.. the overhead didn't seem to trouble this new client my company has. They are using a legacy VB6 application as a front-end. They're ...
0
votes
1answer
2k views

Attaching MDF File that appears to have been truncated by the OS

I've got an MDF and LDF file from a dead server that I'm trying to attach to another instance of SQL Server. However running the following create database statement USE [master] GO CREATE DATABASE ...
0
votes
1answer
151 views

Verify SQL Server Mirroring failover is successful

We have database mirroring configured as "high safety without automatic failover" on 23 databases. Both partners contain principal and mirror databases. I created two scripts that would failover ...
0
votes
3answers
325 views

query maintenance plan schedule

can I query the schedule of a maintenance plan? I want to automate checking that backups were run. Thanks
3
votes
2answers
1k views

SQL 2008 - Transaction log is full

We have some issues with the transaction log files We have SQL Server 2008 Our situation: Every night, we have many jobs that runs on the server by SQL Agent Some jobs stop because the transaction ...
1
vote
1answer
906 views

T-SQL for autogrowth of multiple data files

I can't seem to figure out the problems with my script to alter SQL Server 2008 database and file growth. There are two data files and a log file, all which need to have Autogrowth ON. Does this look ...
1
vote
6answers
4k views

Restore Database User to Server Login on SQL Server 2008

We have a database backup we need to restore on a server that doesn't have the logins for the database... all the users are in the database though so we are hoping we can restore it this way? I've ...