|
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: GTM |
last post by:
I'm trying to backup several databases to UNC folders. I'm able to do it
manually for each database, but when I set up the maintenance plan it fails
because SQL tries to use the SQL administrator account to push the data.
The million dollar question is how does one change which account is running
the maintenance?
|
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: Jim Andersen |
last post by:
Hi there,
Used the wizard to create a maintenance plan for a db. But it fails most of
the time. I checked the log-files.
At 1.00 AM, it runs the "Optimizations" job for 6-9 seconds. It succeeds
always.
At 1.05 AM, for 1 second, it runs "integrity check", but most of the time it
fails, and says that it couldn't switch to single-user because other users
|
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: pk |
last post by:
I have a problem that I would like to resolve through scripting, but
I'm not sure how to go about it (or if it's even possible.)
We're trying to work around a bug (
http://support.microsoft.com/default.aspx?scid=kb;en-us;303292&Product=sql2k
) that requires us to split up our maintenance plan into two parts.
In the first, we backup "All User Databases". This runs fine. The
second maintenance plan backs up the transaction logs and then...
|
by: Derftics |
last post by:
Hello,
I am creating a transaction log backup in maintenance plan wizard for a database with bulk-logged recovery model but I am receiving this error. "The selected database does not have the Recovery Model property set to full. This is required in order to back up the transaction log." Kindly tell me how can I make a transaction log backup job for a database with nulk-logged recovery or is it possible?
I have done some research but I...
|
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: 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: 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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
|
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...
|