How does SQL Server respond when the NT Server's clock is set to a time that is earlier than the current time? Someone on my team seems to think that this is a problem for SQL Server, but I am not sure.
View 5 RepliesWhen i log in to my server i dont have the clock in the System Tray? Any ideas on how to fix this. I also keep getting a W32time warning in the system event viewer, i dont know if that has anything to do with it.
View 2 Replies View RelatedHello,I'm trying to create a simple back up in the SQL Maintenance Plan that willmake a single back up copy of all database every night at 10 pm. I'd likethe previous nights file to be overwritten, so there will be only a singleback up file for each database (tape back up runs every night, so each daysback up will be saved on tape).Every night the maintenance plan makes a back up of all the databases to anew file with a datetime stamp, meaning the previous nights file stillexists. Even when I check "Remove files older than 22 hours" the previousnights file still exists. Is there any way to create a back up file withoutthe date time stamp so it overwrites the previous nights file?Thanks!Rick
View 5 Replies View RelatedI am having a nightmare of a time with my Sql Server 2005 Express. My computer crashed on Friday the 13th - of course. I saved all my files onto another drive and wiped out C: I brought everything back in but I started a new file for my Visual Basic projects. After asking questions I found this was a major no-no So I brought my original folder back in. This solved some of my problems I was having with Visual Studio and Visual Web, but I am continuing to have problems with Sql Server. I will explain these two problem they may be related, I don't know. When I run my Visual Website on a server I get this message:
An attempt to attach an auto-named database for file(then my file name)failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
And my second problem is when I attempt to run Sql Server Management Studio Express I get this error message:
There is no editor available for (then my file name) .mdf
Make sure the application for file type(.mdf)is installed.
how can I dynamically set up the period between now and one year before in a query like this:
where cast(LEFT(period_start,8)as DATE)>='2014-10-01'
and cast(LEFT(period_end,8)as DATE)<='2015-09-30' and
Â
Practically in the second or third of every month I need to run the period late of one year.
Does anybody know of a way to rollback SQL Server 2005
databases back to SQL Server 2000? Is there a way of doing it without
resorting to Copy Database Wizard? I love to find a way of attaching a SS 2005 database
to a SS 2000 instance without any issues.
I recently upgraded to SS 2005 and I am very unhappy with the SS 2005 and I
want to rollback to SS 2000, which was a lot more stable. I am having
several major issues that are affecting my whole company's day-to-day
operations and the managers are not happy. Some of the issues include
night time batch running very sluggish for no apparent reason. This is a
biggest problem because it only occurs once or so a week and causes a disturbance
with the daily activities when the night time processing isn€™t completed on
time. The rest of the time, the batch processing runs great, even a little better then on SS 2000. I
don't believe it is a matter of my application needing to be retuned because if
that was the case, then why isn't it running sluggish every night? Also,
it's never the same day that the sluggish behavior occurs. If it was occurring
on the same night, then I would have something to investigate within our
application, but it doesn't. Another issue that I am having involves a
night time job that restores a copy of the production database to the Data
Warehouse server to be used for updating the data warehouse. Again, most
of the time it runs great (~2 1/2 hours), but once or twice a week, it goes
stupid and takes 6 1/2 hours for no apparent reason. Again, it is not happening
the same day either, which could give me something to invesigate. On SS 2000, this same job ran flawlessly. Never I did I run into situation that the
database restoration took that long to run. Even another issue involves a SQL Server Agent Job that was put into suspended
state. What's a suspended state and how can I get it out of suspended
state? I can find no information about suspended state in BOL. I
did a Google and nothing came up. If this suspended state was put
in for security reasons, great, but then tell me how I can remove the suspended
state. I am also not happy with the
fact that I can't get accurate information about the queries that are actively
running at that particular moment. In SS 2000, when I noticed high CPU
usage on the server, I would run the sp_who2 active stored proc and it would
show me all the active thread and how much CPU it was consuming. I would
then find the running threads with the highest CPU numbers and investigate the
query and see if we could improve it. Now in SS 2005, I get in the same
situation and run the sp_who2 stored proc, and there is no smoking gun.
All of the active threads are showing very little CPU usage, which I am very
suspect of. What the heck happen to sp_who2? I looked at some of
the other ways of looking at running processes (i.e... sys.sysprocesses) and
they don't appear to be giving the information that I need.
I am very unhappy and I just want to roll back to SS 2000 and wait a couple of
years before I upgrade to SS 2005.
Dave Brown
HI I just signed up this forum,I wanted some help.How can i add sql clock on VB Form.
Arshad
I am trying to develop an attendance application which calculates the shift details as per the Clock IN OUT Data , the following are the table details
CREATE TABLE [dbo].[INOUTData](
EmpID VARCHAR(10),
CLockDate Date NULL,
[INTIME] Time NULL,
[OUTTIME] Time NULL,
) ON [PRIMARY]
[Code] ....
-- I am trying to get the data as follows combining these two tables
EMpID ClockDateSession1StartTimeSession1EndTimeActualSession1StartTimeActualSession1EndTime
Session2StartTimeSession2EndTimeActualSession2StartTimeActualSession2EndTime
E1 28-Jan-201408:00:0012:00:0007:50:0012:15:0017:00:0021:00:0017:15:00 20:55:00
E2 28-Jan-201408:00:0012:00:0008:30:00NULL17:00:0021:00:0016:15:0021:55:00
E3 28-Jan-201408:00:0012:00:00NULL 11:34:0017:00:0021:00:0016:15:00 21:55:00
E4 28-Jan-201408:00:0012:00:0008:30:00 11:34:0017:00:0021:00:00NULL 21:55:00
E5 28-Jan-201410:00:0014:00:0010:35:0014:44:0019:00:0023:00:0018:55:00 NULL
Right now i am using a stored procedure which traverses through each record and does the job.
Is there any way to do it with Pivot, or queries instead of cursors.
All ,
I need to convert the given time into 24 hour clock .
I have the two tables out of which one contain time in 12 Hr clock and another contain time in 24 Hr clock and i need to make a join on this colum by converting 12 Hr time in to 24 hr clock time.
Please help ..
Regards,
Ashish
We get the following errors at the same times every night (between about 3AM and 4AM) on our distributor (ss2000). The publisher and subscribers do not log anything unusual during this time period but are busy. The distribution agents time-out with:
Timeout expired (Source: ODBC SQL Server Driver (ODBC); Error number: S1T00)
---------------------------------------------------------------------------------------------------------------
exec sp_MSadd_repl_commands27hp 2, N'pacefs', 0x0013D1040000A2BF00010013D119000008080142000003D70002F4A10000001E0003A1000000003E01000029007B00430041004C004C002000730070005F004D00530069006E0073005F00740062006C005F0063006F006E00760065007200730069006F006E005F006400610074006100200028003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F0029007D00060000004C007B00370030004300460037004100420041002D0041003600430034002D0034003300340045002D0039003500310045002D003300360037003000410044003500320036004500330035007D000C00050000005765656B310C00000C00000043757272656E744D6F6E746801000000010000000C000000060000003173742054440100010000000C00000008000000484C4320576573740C00000009000000526566696E616E6365010000480000000C000000050000004E61696C730C000004000000323239340C000000090000004A656464204C6172610C00000C0000004C656E64696E6720547265650C000000000000000C00000007000000333431353338320C0F0000003239353433323330202020202020200E00002E0032003000300037002D00300039002D00310030002000310032003A00350036003A00330034002E003400360030000C000B0000004C454E44494E47545245450C130000004C454E44494E4754524545204E4554574F524B0C09000000524546494E414E43450100000000000001000000000000000713040016003400300032003000300030002E0030003000300030000713040016003400300035003000300030002E00300030003000300001000000540000008E01000000000000010000000000000001000000000000000C000000090000004A656464204C6172610C0000050000004E61696C730C000008000000484C4320576573740C000000060000003734363937330C0002000000464C0C0000000000010000002005000001000000480000000100000001000000010000000000000001000000000000008E, 0x0013D1040000A2BF00010013D119000008080142000003D70002F4A20000001E00033D000000003E01000029007B00430041004C004C002000730070005F004D00530069006E0073005F00740062006C005F0063006F006E00760065007200730069006F006E005F006400610074006100200028003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F002C0020003F0029007D00060000004C007B00370031003500370037004500420031002D0034003200450035002D0034004300420041002D0039004600320036002D003300360037003000420030003400450039004200370030007D000C00000000000C000000070000004D6F6E74683131810C0000000A000000556E61737369676E6564818C0C00000006000000457175697479810C040000004E6F6E650C000000030000003931360C0C0000004E69636F6C61205365
exec sp_MSadd_distribution_history 7, 3, N'The process is running and is waiting for a response from one of the backend connections.', 0x0000000000000000000000000000, 0, 0, 0.00, 0x00, 1, 0x0000000000000000000000000000, 0, 0x01, 0x01
This is driving me crazy as there appears to be little to go on and I don't know what to do next.
Any useful suggestions?
Thanks,
Michael
New to Database Mirroring and I have a question about the Principal database server. I have a Database Mirroring setup configured for High-safety with automatic fail over mode using a witness.
When a fail over occurs because of a lost of communication between the principal and mirror, the mirror server takes on the roll of Principal. When communication is returned to the Principal server, at some point does the database that was the previous Principal database automatically go back to being the Principal server?
I need to run two reports each of A5 Size to run back to page and print on single A4 paper means in 1st half Sale bill will be printed and in second half Gate Pass Will Be Printed both report will be on same page and size and shape should be maintained. How to do it.
View 4 Replies View RelatedHello,I am hoping you can help me with the following problem; I need to process the following steps every couple of hours in order to keep our Sql 2000 database a small as possible (the transaction log is 5x bigger than the db).1.back-up the entire database2.truncate the log3.shrink the log4.back-up once again.As you may have determined, I am relatively new to managing a sql server database and while I have found multiple articles online about the topics I need to accomplish, I cannot find any actual examples that explain where I input the coded used to accomplish the above-mentioned steps. I do understand the theory behind the steps I just do not know how to accomplish them!If you know of a well-documented tutorial, please point me in the right direction.Regards.
View 2 Replies View RelatedHi, For Asp.net project i have used backend as sql server database.My database name is Traveldb.i want to take the backup for this database in SQL Server as a "Filename.sql". Please tell me the steps to follow to take the backup file as SQL Script File extension.Thanks & Regards,Laxmi
View 1 Replies View RelatedHi there.
I'd like to backup below item from server to my client ( local ) .
1. DTS package
2. All jobs in SQL Server agent
How can I do ?
Please advise me
Hi everyone. I just want to ask if the triggers I have created in my tables will be included in the back-up of my database? Hope to hear from you soon. Thanks in advance.
View 5 Replies View RelatedHi folks,I was working on MS sql server 2005 evalution where i have built a number of databases. However, i came to discove that the evalution version has expried before i finished my work. Now i have disinstalled the sql server 2005 and installed the Sql express edition.My concern here is how can i keep my databases so they can work with sql express edition?Thank you very much in advance.
View 1 Replies View RelatedHI allI want to take a back of my serverthere is 40 data base into my server and i have to take back of every database every day is there any way which can take back up of hole server at one time.regard
View 1 Replies View Relatedhi all,
View 2 Replies View RelatedI am trying to back up database to a different server. I am able to map the serve to my current ones, however, when I go to Enterprise Manager - back up DB, I can not see the mapped drive from back up file location, I wasn't able to see any other disk location but the local drives.
Can somebody tell me how can I back up database to a different server from Enterprise Manager or any syntax?
Thanks.
Hello,
Is it possible, into a DTS package, to get back the name of the SQL server on which it is registered (through a property of the DTS package for example) ?
I know it's possible to see the name of a server with the system variable @@servername or this request "Select srvname From master..sysservers" but I don't know how I can allocate the value of these solutions to a variable into an ActiveX script...
Could someone help me ????
Thanks in advance !
Sorry for my english but I'm french :)
Hello,
I want to schedule an automated nightly backup of a database to another server on the network (backing up a 6.5 database on Server3 to Server5). File sharing is turned on for Server5 with all permissions, so that shouldn't be a problem. Server 3 sees the Server5 backup location fine from the NT Explorer, proving the two servers are talking to each other okay. Both servers have an NT account called SQLServer with the same name and password and full administrative privileges, which Server3's SQL Executive service uses to log on with (SQL Server is not installed on Server5).
When I try to back up to Server5 (whether to Server5DDRIVETBBackupDailyTimeAndBilling.dat or to a mapped drive F:TBBackupDailyTimeAndBilling.dat) an error message is returned saying "[SQL Server] Can't open dump device 'Server5DDRIVETBBackupDailyTimeAndBilling.dat' , device error or device off line. Please consult the SQL Server error log for more details." The error log says "Backup device 'Server5DDRIVETBBackupDailyTimeAndBilling.dat' failed to open, operating system error = 5(Access is denied.)"
Any help would be greatly appreciated.
Regards,
Karl Simanonok
Professional Presence Providers, Inc.
I am trying to set up an Access db to connect to a SQL server back end. I created a system DSN and then linked the Access db to it; no problem when the Access db is local.
When I upload the Access db to the website, it refuses to connect; I keep getting this error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQS2008' failed.
Here is the ASP code in the web page (pretty plain vanilla):
DIM Connect2
SET Connect2=Server.CreateObject("ADODB.CONNECTION")
DSNTemp="Driver={Microsoft Access Driver (*.mdb)}; "
DSNTemp = DSNTemp & "DBQ=" & server.mappath("yetanothertest.mdb")
connect2.Open DSNTemp
SET onwash2=Connect2.Execute("SELECT * FROM LineStandardPolicies")
Any help would be appreciated. Thank you!
Hi all
Hope you can help.
I've been using MS Access as a backend content server on websites for some time. However, I want to move to Sql Server but am struggling a bit with some of the concepts.
I want two types of users of the website.
1 User who can view data as a iusr_guest type user (no login)
2 can view/ edit data as a datawriter (website administrator).
With Access I would simply have a table or another db containing user info. If a user logged in and was accepted then a IIS user session would be created and they could edit the db.
Any views on how this type of simple db access should be managed using sql server?
best regards
chubster
What is the best way to back up sql server to a remote site so that if we had total data loss locally I would be able to restore and get back up and running as quickly as possible. I have a remote file storage option that I use and I currently store a MSAccess version of the db there. I assume there is a much better solution to this. Can someone "upgrade my knowledge" please?
Thanks a ton~
What is the best way to back up sql server to a remote site so that if we had total data loss locally I would be able to restore and get back up and running as quickly as possible. I have a remote file storage option that I use and I currently store a MSAccess version of the db there. I assume there is a much better solution to this. Can someone "upgrade my knowledge" please?
Thanks a ton~
i am a IT administrator ! I am now administer the webserver run SQL server 2005, running backup symantec exec . I want to know there is other better tool for sql backup ! I really dont like database much ! just want to know enough for administering them :mad:
View 2 Replies View RelatedOne of our engineers here by mistake deleted some very important data without any begin trans block and we need the data back very badly.. We have not closed the session as of now.. The engineer was logged in as sa to the DB.
Can someone please help soon on urgent basis...
i want to ask why database i cannot back up or expand if i make expand the database the message showing "the database (database name) is not accessible. (object explorer)before the database is working fine,
View 9 Replies View RelatedI need to back up a production database on one server and then copy it to a test server wherel it will be restored. The problem is that I don't know where to move the file to on the production server before I restore it. Is there a special folder I need to copy the file to? I see a folder named ProgramFilesMicrosoft SQL Server but beyond that I have no idea where to copy the file so that it can be restored?
Can someone help me out please?
Hi,
i wanna know how to use rollback in sql server without actually using transaction...
is there any way i can do that?
thanx in advance
Hi,
I am using SQL Server 7.0.
I have sa rights.. I went to the Enterprise Manager and choose a Server and under that server choose a database.
Then I clicked "New Maintenance Plan" and set up a Backup plan for my database.
The problem when I checked the next day the database was not backed up. I have tried this on other database and it has always worked. Why is it not working now? There is enough space on the Drive I am backing to.
Am I missing something?
Thankx
KP
emergency help, our server1 is down, we need to restore everything from tape using server2, but when i put the tape in the server2, it said "unreadble media", what should i do to restore everything? How can the tape to be readble? Thanks, thanks.
View 14 Replies View Related