|
by: Mark S |
last post by:
I have a db maintenance plan which is set to backup (then truncate hopefully)
the transaction log. In order to backup a transaction log the db must be in
single user mode so the maint. plan fails. How do you automatically set the db,
in single user mode, for the transaction log to be backed up then truncated?
Also, I manually set the db in single user mode and it shows itself to be in
single user mode yet the number of users in the db...
|
by: Alexey Aksyonenko |
last post by:
I know that SQL Servers can be set up to forward alerts to a single
SQL Server. I am wondering if same would be true for the Maintenance
Plan Reports. Basically, I want to have only one SQL Server on the
network that has the SQL Agent Mail profile set up, and to use that
server for all e-mail and/or pager notifications for all alerts and
events raised by any of the SQL Servers on the network, including
Maintenance Plan reports. Is this...
|
by: Michael Nostrom |
last post by:
Hello,
I'm trying to configure my MSDE 2000 installation to dump all databases
and transaction logs to disk every night to be backed up by our backup
software. All goes great in configuring the maintenance plan until I get to
the retention part. I want to configure the backup plan so that it'll delete
OLD backup older than 2 days. When I click the 'Remove files older than" box
and choose 2, but there's nothing in the drop-down box where...
|
by: nielsonj1976 |
last post by:
I am getting a failure on the db backup job of one of my maintenance
plans. It is coming back with the generic error message of,
"sqlmaint.exe failed. (Error 22029). The step
failed."
I then checked the Database Maintenance Plan History page, but this
shows all the steps having run successfully. If I check the drives for
the actual backup files, they exist and look healthy too!
|
by: microsoft . public . sqlserver |
last post by:
I am using SQL server 7.0. After restoring all the databses (Except
distribution) Everything seems to be working fine except the backup
maintenance plan. I put following detail in the maintenance plan
"General Tab:
Plan Name --- DB Maintenance Plan1
() All Databases
Optimizations tab:
|
|
by: mmohammed |
last post by:
Hi All,
I am trying to Schedule a full backup and a transaction log backup in sql server 2005 using Maintenance Plan.My requirement is to schedule these two backups at different time say 10pm and 10.30 pm daily.But when i am using Maintenance Plan it only allows me to schedule both jobs at one time that is
it shows only Maintenance Plan Schedule in which you can have only one schedule.
Can anyone please tell me how to schedule these two...
|
by: Zvonko Bi¹kup |
last post by:
Hi!
When I try to create maintenance plan using wizard in SQL Management Studio
for SQL Server 2005 Standard Edition, I get the following error:
TITLE: Maintenance Plan Wizard Progress
------------------------------
Create maintenance plan failed.
------------------------------
|
by: Neff |
last post by:
I have a clustered installation of SQL Server 2005 running on Windows
2003 with SSIS installed on the cluster.
I'm running SQL Server Management Server on one of the cluster nodes
and I can right click and create a new maintenance plan and drag a
'Back Up Database Task' into the plan. (Using the wizard also works.)
However if I try to open the the Backup item in the plan I get the
following error
|
by: fniles |
last post by:
I have created a backup maintenance plan in SQL Server 2005. Is there any
way to run/execute this SQL Server backup maintenance plan from VB.NET ?
Thank you.
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|