iyyappan.murugappan (2/13/2011)

---

Hi Grant Fritchey,

Thanks for your suggestion, But I already tried Red Gate some time back. I dropped this software due to following issues.

01. Not able to restore if the...

No one here knows what questions an interviewer will ask, so getting a list of questions may not be of much help anyway. Also, answers to any questions can vary...

I think your backups will be smaller just from deleting the data, so maybe the shrink won't make any difference to backup size.

Is this an expected situation when changing the SQL Service account ?

Or did I do something wrong initially ?

I'd like to avoid any problems when I do the production servers.

Most of my databases are "normal" and are up to 200 gig, but I have one that is 1.2 Terebytes and contains 90% image data. (Voice recording migrated from...

I was tempted to choose the wrong answer on purpose just for fun, but I have enough wrong answers already !

Which options (if any) are typically used with checkdb as part of normal database admin work, not in a corruption situation ?

How would that help ? Isn't that for renaming the server ?

I just changed the Service account to LocalSystem, restarted, changed to my new SQL Service Account, restarted, and...

Do you also have SQL 2008 on the same server ?

Another thread suggests that might be a problem with maint plans .... just a guess

http://www.sqlservercentral.com/Forums/Topic1052208-357-1.aspx

Something like this ? This assumes you don't clear your full backup history from msdb. This shows the average backup size per month. You can extrapolate actual database size.

select...

You can use variables in dynamic SQL. Here's a snippet:

SET @Cmd = 'BCP "SELECT * FROM ' + DB_NAME() + '.dbo.MyTable" queryout "' + @Folder +...

SKYBVI (2/8/2011)

---

I couldn't get wat you meant by command inside a sql agent ???

I am the only guy who does the backup so im pretty sure that the backups are...

Can you post the exact message ?

Do you mean the SQL services stopped, or the entire server shut down ?

loki1049 (2/4/2011)

---

Ok so I have a developement database that I back up every week by right clicking on the database > Tasks > Backup. Backup type is FULL. Backup component...

Run your query to find the # of days and put that in a variable:

set @NumberOfDays = QueryGoesHere

if NumberOfDays >= 2

then

send email