database change detect
Thu, 26 Jun 2008 13:00:59 +0300
Hi,
is there any way to detect if user stops sql, changes mdf and ldf file with
a modified one and starts again.
Thanks
...
|
Restore backup set
Tue, 24 Jun 2008 18:25:41 +0530
Hi all,
How can I restore a database backup set created from sql server 2005
developer edition to sql server express 2005?
Vijayakumar ...
|
backup script help!
Mon, 23 Jun 2008 09:58:23 -0400
Hi,
I am having a very difficult time trying to figure out how to write a script
for a SQL backup. I will try and explain what I am trying to do.
The majority of our computers out at customer sites are running access
databases, however a few other computers are running on a SQL Database.
Currently we are ...
|
Re: osql to unc path
Mon, 23 Jun 2008 02:22:18 -0700 (PDT)
On 20 Jun, 11:35, "Andrea Montanari" <andrea.sql...@virgilio.it>
wrote:
> hi Duncan,
>
>
>
>
>
> systemtek wrote:
> > Hi,
>
> > If i try to backup to a UNC path it fails but if i try local it works,
> > any idea ?
>
> > for example, this works ok :
>
> > backup database model to disk = 'C:\Backup\Dai ...
|
MSDE 2000 SP3A upgrade
Mon, 23 Jun 2008 00:18:00 -0700
I have upgraded a MSDE 1 database to MSDE SP3A.
The system in question currently connects remotely to a SQL Server 7 server
(this is being upgraded to SQL Server 2005 in the near future)
The upgrade appears to work but once the application starts we get the
following error messge when one of the local pro ...
|
How to get rid of MSDE for AdminDB
Sat, 21 Jun 2008 05:41:22 -0400
I installed some software on my system and now the system always
installs and configures MSSQL Server. I would like to get rid of this
overhead but I cannot see any way to remove it. Any help woulb be
appreciated? ...
|
osql to unc path
Fri, 20 Jun 2008 02:22:09 -0700 (PDT)
Hi,
If i try to backup to a UNC path it fails but if i try local it works,
any idea ?
for example, this works ok :
backup database model to disk = 'C:\Backup\DailyDatabaseBackups
\live.bak'
go
this fails :
backup database model to disk = '\\myserver\DailyDatabaseBackups
\live.bak'
go
Thanks
...
|
|
|
SQL Server Agent hangs on startup
Wed, 18 Jun 2008 08:38:01 -0700
We have tried to upgrade some clients from msde 1 to msde 2000 and although
they seem succeed when we start the application this fails.
We then tried to rollback the application by using an XP restore point and
reinstating the .MDF and .LDF files. On reboot the system appears to be
working and the applicati ...
|
MSDE upgraded to SP4 but showing SP2
Thu, 12 Jun 2008 16:56:48 -0500
I just upgraded my SQL 7 to SP4 (actually MSDE 1.0). I used sql70sp4.exe
from the Microsoft site, ran the setup program, and everything seemed to
work fine, and I restarted my system. Now the value of @@version is this:
Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86)
Apr 9 2002 14:18:16
Copyright (c) ...
|
MSDE 1 Upgrade to MSDE 2000 SP3A
Wed, 11 Jun 2008 07:55:00 -0700
I am trying to upgrade a number of remote sites from MSDE 1 to MSDE 2000 ready.
Some sites are XP/SP1 and some are XP/SP2. As yet I have had no problems
with XP/SP1 sites but on some of the XP/SP2 sites I get the following error
message:-
Starting custom action SetFileAndRegACLs()
Failed to set file secur ...
|
