I'm trying to write some T-SQL code for adding some fills and thrills
to backups but ran into a snag. Is there a way to query what backup
model a database is using? I can see it if I right click a database,
go to properties, select the options tab, and then can see the current
model (full, bulk-logged, and simple) but I would need to hard code
each database. In the spirit of automation, I'd rather query for the
type and then work around that instead. But I've been all over the
master database and can't seem to find any field that will indicate
the backup type.
Any guru's out there that can point me in the right direction?
Thanks,
Utah 2 1930
Hi Utah,
Try DATABASEPROPERTYEX in Books Online: http://msdn2.microsoft.com/en-us/library/ms186823.aspx
You'll want the Recovery property.
Thanks,
KenJ
On Mar 15, 5:45 pm, Utahd...@hotmail.com wrote:
I'm trying to write some T-SQL code for adding some fills and thrills
to backups but ran into a snag. Is there a way to query what backup
model a database is using? I can see it if I right click a database,
go to properties, select the options tab, and then can see the current
model (full, bulk-logged, and simple) but I would need to hard code
each database. In the spirit of automation, I'd rather query for the
type and then work around that instead. But I've been all over the
master database and can't seem to find any field that will indicate
the backup type.
Any guru's out there that can point me in the right direction?
Thanks,
Utah
On Mar 15, 7:43 pm, "KenJ" <kenjohn...@hotmail.comwrote:
Hi Utah,
Try DATABASEPROPERTYEX in Books Online:http://msdn2.microsoft.com/en-us/library/ms186823.aspx
You'll want the Recovery property.
Thanks,
KenJ
On Mar 15, 5:45 pm, Utahd...@hotmail.com wrote:
I'm trying to write some T-SQL code for adding some fills and thrills
to backups but ran into a snag. Is there a way to query what backup
model a database is using? I can see it if I right click a database,
go to properties, select the options tab, and then can see the current
model (full, bulk-logged, and simple) but I would need to hard code
each database. In the spirit of automation, I'd rather query for the
type and then work around that instead. But I've been all over the
master database and can't seem to find any field that will indicate
the backup type.
Any guru's out there that can point me in the right direction?
Thanks,
Utah- Hide quoted text -
- Show quoted text -
That could not have been more perfect. THANK YOU! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: A.M. de Jong |
last post by:
Hi,
Every day we perform a full database backup.
(during the night).
Since we need no "additional" backups we had the problem that the
transaction log file grows and grows.
Therefore now just...
|
by: Tim Morrison |
last post by:
MSDE2000
I have an application in which I am running a TSQL command of BACKUP DATABASE and RESTORE DATABASE for the backup and restore commands for my application. For testing purposes, i did the...
|
by: Iain Hosking |
last post by:
I am running a SQL Server 2000 installation with several databases. Each
database and log is backed-up using a maintenance plan.
The scheduled maintance plan for the latest database does not run,...
|
by: deprins |
last post by:
Hello,
I have run into some problems with logfiles and backup logfiles (MS
SQL server). I have read much about them but uptil now I dont seem to
grasp how it works. Specially the part of working...
|
by: Wanhua Yi |
last post by:
Hi all,
anybody out there with experience in using EMC's Time Finder Software
and DB2 UDB EEE on AIX ? Especially in using BCV for Backup ? Any white
papers ?
|
by: Andy Davis |
last post by:
I have a two tables, Users and Requests, the latter which displays the daily
log on's of 20 users. Both tables are related by a one-to-many relationship
in the Requests table via the UserId field....
|
by: Karen Hill |
last post by:
SELECT surgeries.*, animals.*
FROM surgeries INNER JOIN animals ON .=.
AND WHERE ((.=Date()) Or
.=Date());
I'm trying to write a query that joins two table together, animals and
surgeries...
|
by: alwinkotiya |
last post by:
Hi all,
If I set recovery model SIMPLE then truncation of log files will be
automated , but I will lose
database changes made since the last backup was taken.
Is there any way to automate...
|
by: m19peters |
last post by:
We have a script that I had to rework a little bit for 2005 that does
a full backup for every database on the server... For some reason on
some nights the script does not backup all databases......
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |