|
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: serge |
last post by:
Running SQL Server 2000 Enterprise Edition SP3. The database is also
used by Microsoft Project Server 2002 and also has OLAP views, so the
database is being used to view/run cubes in the Analysis Manager.
What is the best way of shrinking the database size and its log file too?
Is there an automatic way to do this with a maintenance plan or i have
to manually run a SQL statement periodically?
What are the best practices?
|
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: JIM.H. |
last post by:
Hello,
What is the easiest way to give a system maintenance message to users who
try to run an asp.net application. I do not have separate development and
runtime environment, I just need to figure out a way to return a message back
to user while I am changing application.
Thanks,
Jim.
|
|
by: mkhmer |
last post by:
Hello,
I want to have my site able to alert User and then Disconnect all current
user from accessing the pages for website maintenance purpose.
If anyone have any idea of this aiming?
Thanks,
|
by: vikramp |
last post by:
Hi,
I want to know how to setup the "Under Maintenance" page for the
website?
Here is the thing:
I have application setting in web.config called "MMode". I set it to
"Y" when I need to do site maintenance such as changes in the backend
database, etc.
|
by: editormt |
last post by:
Software maintenance is an important part of the software development
activity, but it is also the less discussed. A recent poll seems to
show that the part of maintenance in software development budget is
going down. Why?
Question: what percentage of your software development budget is
devoted to maintenance. Maintenance is defined as process of
correcting, enhancing and optimising deployed software.
25% or less of the budget...
|
by: Mike Gleason jr Couturier |
last post by:
Hi,
What's a clean way to redirect users on an information page while doing site
maintenance...
Can we do it with urlMappings !? (wildcard "*"?)
Thanks
|
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: 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: 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: 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: 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...
|