Use sp_MSforeachtable

Why did this happen? Was there a power failure?

As last resort you might consider truncating the table or you can run a DBCC CHECKDB statement with the REPAIR_ALLOW_DATA_LOSS option to...

How many databases you have to restore to sync with prod? Are you using EMC SAN?

Thats fine you apply snapshot only once right? Don't you have maintenance window? You cannot insert duplicate key on subscriber table, because there is constraint correct? Did you check the...

As others said if TempDB mdf file has grown during normal business hours there is a reason why it has grown, there is no need to shrink because it will...

Simon-220850 (10/10/2005)

---

Hi,

Our current backup procedureis using a set of maintenance plans set up as a suite of jobs. However we would also like to set-up ajob to robocopy the backup...

SQL Noob (3/9/2010)

---

we have data going back over 10 years. in the 700GB database that had the long recovery time we told our BI people and they split it into...

Angela S. (3/9/2010)

---

NOW i don't remember how I got the copy of the database to begin with. Sorry guys...I"m not having a good week here I'm going...

Lynn Pettis (3/8/2010)

---

GTR (3/8/2010)

---

Most of the time 99% time backup files are not corrupt, We do test them randomly. It is pain to test each and every backup file daily...

Most of the time 99% time backup files are not corrupt, We do test them randomly. It is pain to test each and every backup file daily after backups.

As a DBA if you don't have backups then it's time to usp_updateresume :hehe: We have SCOM alert and SQL alerts for monitoring jobs.

EnjoY!

Elliott W (3/8/2010)

---

I work with a number of environments that the backups are not done locally at all, they are all written to a fileshare on a file server that...

jpoe-838861 (3/5/2010)

---

Hi,

Is there any way that when creating a new SQL login and creating the user for that login that it would get disabled? I created a login and...

You just have duplicate at subscriber. check these steps, it should fix.

http://www.cryer.co.uk/brian/sqlserver/disagnt_cnidkriowui.htm

I wouldn't prefer Back up and Restore method for Initial snap shot of articles, what is the database...

d-to (3/7/2010)

---

If we have a sql server instance that contains potentially 50+ dbs each with replication (used to move data for reporting) - what are some potential problems to expect?

Is...