|
|
-
Abi Chapagai Commented 2 Years ago through Ask
It does have, you do not see it in the drop down list, because you have a database in simple recovery model. In order to do the log backup, YOUR database MUST be in Full Recovery Model. Check your DB recovery mode, and see if that options exists....
|
-
Abi Chapagai Commented 2 Years ago through Ask
Doug,
There are bunch of articles about sql server backups, their recovery models and how they work. Few of the links are:
[http://msdn.microsoft.com/en-us/library/ms175477.aspx][1]
[http://www.simple-talk.com/sql/backup-and-recovery/sql-se...
|
-
Abi Chapagai Commented 2 Years ago through Ask
Doug,
First of all Welcome to the DBA club.
Everyday when i get in to the office i would do the following items.
- Review all database backups
- Review all nightly processes.
- Review the SQL Server error log for
any errors ...
|
-
Abi Chapagai Commented 2 Years ago through Ask
Doug:
The transaction log stores changes in three parts:
- Backed-up records: This section
contains changes that were committed
the last time we backed up the
database.
- Inactive records: This section
contains committed ...
|
-
Abi Chapagai Commented 2 Years ago through Ask
If your database is a production database, i would strongly advice you to change it to full recovery model and set up the log backup to run every 15 minutes, you can change it at any time. Take a full backup prior changing it to be in safe side and then...
|
-
Abi Chapagai Commented 2 Years ago through Ask
Doug, you can run this script off hours and i would not recommend running shrink command agains live db during peak hours. But make sure that there are no active transactions before shrinking the file....
|
-
Abi Chapagai Commented 2 Years ago through Ask
My next question is, is your production database in simple recovery model? My next question is what type of replication are you using? And how you could do transactional replication if the database is in simple recovery model? I am confused now!!! In...
|
-
Abi Chapagai Commented 2 Years ago through Ask
Well, if there is a replication going on, you have to check if the replication is working properly....
|
-
Abi Chapagai Commented 2 Years ago through Ask
Is this database used for replication? This message says that the database was or is marked for replication.
Thanks...
|
-
Abi Chapagai Commented 2 Years ago through Ask
Use DBCC OPENTRAN command to determine whether an open transaction exists.
DBCC OPENTRAN returns the following result set when there are no open transactions in the transaction log:
No active open transactions.
DBCC execution completed. If DBCC ...
|