Viewing 15 posts - 751 through 765 (of 781 total)
I had the same problem few days back...
When I created one mainteneance clean task and pointed to that folder contaning sub folders(wid .bak file) then, the job ran...
July 20, 2010 at 9:15 am
It was newly built server...so didn't check it earlier..
I got through now...restored successfully after the 2 changes as mentioned above..
July 20, 2010 at 6:46 am
@ above all.....
I made 2 changes
1) in server properties-->connections-->remote query timeout changed from 600--> 0
2) started the sql server browser (sql server configuration manager--> services)(it was off earlier)
Now the...
July 19, 2010 at 2:52 pm
@ Ray mond...
Is the 410 GB drive connected to the server that you are trying to restore the database on? If so, why would SQL Server raise a TCP...
July 19, 2010 at 6:33 am
the database mail profile can be made
the receipients of that profile can be made by adding the accounts
there u can mention the address receving hte mails..
July 17, 2010 at 10:40 am
the restore script also failed with the same error.. 🙁
I restored another database from the same prod server to dev server which went smoothly, but that one was just 1GB....This...
July 17, 2010 at 9:41 am
u can restore on that database itself with choosing hte option overwrite the existing database.
July 16, 2010 at 3:27 pm
the .bak file is generally compressed one,
the original size of database is the .mdf size..
so the .bak file size would be 5 gb
but the .mdf file would be 15...
July 16, 2010 at 3:04 pm
@ jeffrey...
But my database restores starts from 10%, 20% , 30% ...then it stops in between....
it is not that it doesnt start...but after sometime it throws error.
The article explains...
July 16, 2010 at 9:14 am
@ all
I got a new drive 410 gb on my server, Now when i copied the .bak file locally, and then trying to restore it, then also I am...
July 16, 2010 at 6:31 am
@ oomboom
how long does the command run before it gives error?
how are you sharing the file? Normal windows share?
The restoring starts with 10%,20%.....around 50-60% it throws the error
as...
July 15, 2010 at 7:06 am
add a identity column..
its a self increment column
ALTER TABLE XYZ
ADD id_num int IDENTITY(1,1)
July 14, 2010 at 2:17 pm
@ ray mond..
ya u r right, thtsy i wanted to restore it over hte network as i didnt had enough space.
...
I dont know if its advisable to do as...
July 14, 2010 at 8:48 am
@ sql buddy..
The drive has 420GB free space if i delete that 144GB .bak file...but thing is that
when i delete that .bak file and then restore it through SSMS...
July 14, 2010 at 8:35 am
Viewing 15 posts - 751 through 765 (of 781 total)