yerram.santhosh (12/15/2009)

---

1. For each file to be moved, run the following statement.

ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name , FILENAME =...

I do not have a clustered index, but I have 6 non-clustered indexes.

There are lots of ways to archive data.

Backup & restore to different databases. "MyDatabase_20091130"

Save specific tables to a new name "MyTable_20091130"

Scheduled SSIS package, replication, log shipping .....

Idera's latest backup...

I haven't had any "quiet time" to rebuild the indexes yet. (I'm running 2005 Standard, so I can't do online rebuilds :crying:)

Would rebuilding actually increase space in the data files...

B to A is a linked server also ? Same account & permissions ?

All your scheduled jobs are stored in MSDB. If you need to re-install SQL, it would be quite useful to be able to recover your jobs.

Did you try setting "Enable Identity Insert" on the "Mapping" tab ?

cherie-817709 (12/3/2009)

---

My full backup on one of the database is failing with non-recoverable I/O error. I ran consistency check and found some errors there. Fixed that but full backup still...

d.chhabra (11/4/2009)

---

Dear Sir,

I have created batch file for daily backup but I am not able to execute the same. Can you please let me know what further I have to...

Does BCP and Bulk Insert work from SQL to SQL ? All the examples show .csv or some type of non-SQL file involved. I tried to write some code to...

I usually do a character string search to see where an object is used. I don't know how dependable it is either, but better than sys.depends.

Something like:

select name, create_date,...

I'm sorry, I might not have been clear. I'm familiar with how to set batch size in DTS. I was wondering if there's a way to control batch size when...

Sorry, I don't follow. Do you mean advanced properties of a job ?

If backups are failing, so there's no recent backup, would it make sense to detach the database, make a copy of the .MDF and .LDF, then reattach ? Maybe...

Are your databases backed up ?? You might have to re-install, or maybe you can recover them from your MASTER db backup ? Hold out for someone more knowledgeable...