Viewing 15 posts - 3,511 through 3,525 (of 7,187 total)
No, only the stuff you would have got from cat_transaction.
John
June 12, 2014 at 7:02 am
Dax
No, you can stop just SQL Server Agent. Or you could use a proxy account. Bear in mind that will only work for scheduled backups. If you...
June 12, 2014 at 5:46 am
Dax
A differential backs up every page (or is it extent?) that has been changed since the last full backup. The index rebuild was just an example - if anything...
June 12, 2014 at 5:07 am
The reason I created this trigger is because the data will only be inserted one at a time, so if there are two records being inserted then the trigger will...
June 12, 2014 at 5:00 am
I don't know how they import the data from the front end, this is a new system.
I just know they use a third party application to import it. (This is...
June 12, 2014 at 4:20 am
And if I disable the trigger and do another transaction, then it writes the "lost" transaction and the new transaction to the db.
Are you doing your insert as part of...
June 12, 2014 at 3:43 am
SQL Guy 1 (6/11/2014)
You can run differential backup. For these 4 days, it will be smaller than full.
Not necessarily. If, for example, you've rebuilt all your indexes during...
June 12, 2014 at 3:31 am
crazy_new (6/12/2014)
it doesn't store the transaction in the DB until I disable the trigger.
Do you mean that the insert into cat_transaction doesn't happen? If so, it looks like there's...
June 12, 2014 at 3:29 am
Manoj
You can restore a backup made with SQL Server 2008 R2 on a SQL Server 2012 server. Don't forget to change the compatibility level on the database to that...
June 12, 2014 at 3:15 am
You're partitioning your results by NewTitle. If the size of those partitions is smaller than your page size, then you will get all rows returned.
John
June 12, 2014 at 2:51 am
smtzac (6/11/2014)
Total DB size is 790 GB. doesn't this help? My question is what's the appropriate size for this large db after shrinking the log file.
I'm afraid it doesn't help....
June 11, 2014 at 9:02 am
As for the requirement to find row size....
If all your columns have fixed-width data types such as int, datetime and char(100), just divide the table size by the row count...
June 11, 2014 at 8:03 am
ashalatha.cse76 (6/11/2014)
while deleting the cat_id from category table if i want to get a message then how to do regarding cat_id is present in order table
Under what exact circumstances do...
June 11, 2014 at 7:50 am
A good place to start is to look at the 6th June backup. What size was that? Assuming your database hasn't had any significant growth between then and...
June 11, 2014 at 7:45 am
As Gail said, monitor for a week. If you can't wait, query msdb.dbo.backupset to find out what the sizes of your log backups have been. Make sure you...
June 11, 2014 at 7:31 am
Viewing 15 posts - 3,511 through 3,525 (of 7,187 total)