network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 3 years, 7 months |
| seen | May 15 at 3:04 | |
| stats | profile views | 25 |
|
Apr 28 |
asked | SQL Server 2008 Unique Problem for bring DB Online |
|
Apr 21 |
comment |
Full/Differential backup - what's used to determine the differential backup content? cool didnt know that |
|
Apr 21 |
comment |
Move a Database that is in restore mode yeah thats my current solution -_- was hoping for another workaround. im actually using sqlserver 2008 |
|
Apr 21 |
comment |
Move a Database that is in restore mode I get this error when trying to attach the databases: Cannot attach a database that was being restored. (Microsoft SQL Server, Error: 1824) |
|
Apr 21 |
comment |
Move a Database that is in restore mode Bear with me but how do I make sure the files are writeable? |
|
Apr 21 |
comment |
Move a Database that is in restore mode Let me re-run what I did and get the actual error message out. But basically, I stopped the service, copied the .mdf, .ldf and .ndf files over. Went into SMSS and restored from there but met the restore/read-only error in the process. Will report back in an hour or so with findings. |
|
Apr 21 |
comment |
Move a Database that is in restore mode I can't do this because I don't have active directory set up and I kinda hacked my local server to have the same user/pass as my primary DB. I can't do this for my other server (the analysis server). |
|
Apr 21 |
revised |
Move a Database that is in restore mode added 4 characters in body; added 206 characters in body |
|
Apr 21 |
comment |
Move a Database that is in restore mode yeah erm that didn't work due to the database in a restore/ read only mode |
|
Apr 19 |
revised |
SQL Server 2008 Copy Database Wizard: Fail added 254 characters in body |
|
Apr 19 |
comment |
SQL Server 2008 Copy Database Wizard: Fail That's the feeling I got because a few SPROCS that were referencing tables that were not longer used were flagged before that halting the entire operation. See the thing is, I am really trying to move a database that is in restore/stand by mode (it is the log shipping destination db) and this seems to be the only viable channel without breaking the logshipping chain? Do you have any workarounds for this? |
|
Apr 16 |
comment |
SQL Server 2008 Copy Database Wizard: Fail he and i are having the same problem essentially. |
|
Apr 16 |
asked | SQL Server 2008 Copy Database Wizard: Fail |
|
Apr 15 |
comment |
Move a Database that is in restore mode as per the edit, i meant copy |
|
Apr 13 |
awarded | Commentator |
|
Apr 13 |
comment |
Move a Database that is in restore mode cool, i'll test this in a bit but this sounds good! |
|
Apr 12 |
answered | Can't remotely connect through SQL Server Management Studio |
|
Apr 12 |
revised |
Move a Database that is in restore mode added 234 characters in body |
|
Apr 9 |
asked | Move a Database that is in restore mode |
|
Apr 8 |
awarded | Tumbleweed |
