Hi all,
I have two servers one new and one old.
The old server is in production and must run as long as possible.
The new server is supposed to replace the old server.
What is the best way to syncronize these two server so that the new server can the same time as the old server is powered down...
Hi all,
How can I use a tape device connected to another server?
RESTORE DATABASE MyNwind
FROM TAPE = '\\MyServer\tape0' ??
WITH NORECOVERY
NOUNLOAD
/Kent J.
DotNetGnat,
I solved it!
By default, when you initially install IIS 6.0, IIS serves only static content to make sure that the server is secure. The Web Service Extensions node of the ISM is used to permit or to not allow programs that extend this functionality.
So you need to allow ASP. To do...
DotNetGnat,
What was the final solution?
DNG: '..post..exact error message..'
testare: 'I would like to thank..'
It very similar to what I got.
/Kent J.
Hi all,
When I try to browse a asp file directly from IIS with the extension .asp (example: asptest.asp) then I get: 'The page cannot be found'. If I change the same file to suffix .aspx then there is no problem.
I have checked the application extension and seen that .asp is present in the...
Hi all,
I have a include file that I've used for years.
But now I'm shifting to a new server and it doesn't work.
The include file:
<!--#INCLUDE FILE="../System/ConnKundData.asp"-->
=================
Browser error:
Active Server Pages error 'ASP 0131'
Disallowed Parent Path...
SQLBill,
Yes,I have successfully done my restore.
It took 11 hours and 47 min.
===========================
RESTORE DATABASE Kunddata
FROM TAPE = '\\.\tape0'
with recovery
Processed 15402472 pages for database 'Kunddata', file 'KundData_Data' on
file 1.
=======================
/Kent J.
Yes, the backup was on one tape.
I have also tried to attach the database directly but that fails too.
This is from the errorlog:
Starting up database 'KundData'.
Error: 9004, Severity: 21, State: 1
An error occurred while processing the log for database 'KundData'..
I have checked the size...
Hi all,
I have a backuped a database on a tapedevice from an old server that I would like to restore to a new server.
I have created a new database with the same sortorder and name as the old one.
When I run the restore command from EnterpriseManager everything looks good and I'll get...
OK!
I have installed 'Active Directory Management Tools' so what is the next step in the process of migrating users & pwd to the new server from the old?
Open 'Active Directory Users and Computers'?
/Kent J.
Hi all,
I have invested in a new server with Win2003.
How can I import users, passwords and roles from my old Win2000 server to the new server?
/Kent J.
DrSQL,
<<Left panel browse the DB, User Table, Go to the table, right click and Open>>
All the data is displayed immediatly!
... but If run a script from Query Analyzer:
"select * from Table"
or
"select * from DbNamn..Table"
..it takes 60 seconds before all data is displayed.
/Kent J.
Hi all,
I have a server on a corporate network and I suspect a problem with port because the preformance is poor on some applications. How can I monitor that?
/Kent J.
SQLBill,
Yes, I have the correct database i my Query Analyzer.
I have tested on a table with 1000 records (select * from Table1)and if I open the table from Enterprise Manager I'll get immediate response (2-3 seconds). But if I open the same table in Query analyzer I'll now have to wait 60...
Hi all,
I have a strange problem. I can connect to a table, and list records, with Enterprise Manager but not from Query analyzer. What can be wrong? Channel problem?
/Kent J.
OK!
I have change the backupdevice to HP Ultrium 230 -
80 meg/second according to the manual.
136 GB took 44 min = 52 meg/second.
I guess compression is connected to backupdevice and not to the SQL-server backup.
/Kent J.
Hi all,
I have a 136 GB database and for backup purpose I have a SDLT tape backup unit that can take 110/220 GB backup.
This means that the unit can take up to 220 GB compressed data. So, my question is: can the SQL-server 2000 backup program compress the data?
/Kent J.
Thanks!
I copied and pasted the syntax from the VBA editor.
But when I try to run this macro I'm promted to set a macroname. How can I trigger this?
/Kent J.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.