Viewing 15 posts - 3,166 through 3,180 (of 9,253 total)
Beatrix Kiddo (7/16/2014)
Oh, also, would not specifying a catalog make the whole process any slower?Thanks again.
If anything should be faster as it won't have to enumerate all the other databases...
July 16, 2014 at 8:40 am
Beatrix Kiddo (7/16/2014)
Thanks. So does that explain why the activity I'm seeing is in master?
If the users default database is master then yes
July 16, 2014 at 8:39 am
SQLAddict01 (7/16/2014)
July 16, 2014 at 8:38 am
a linked server can (and arguably should) use a default catalog. If one is not specified the linked server will allow access to all databases the user has access to....
July 16, 2014 at 6:03 am
nvalia (7/15/2014)
Current SQL Server 2005 SP2 is on Windows 2003 Server (Not to be used post Migrating Databases)
SQL Server 2012 is going to be...
July 15, 2014 at 3:31 pm
nvalia (7/15/2014)
My concern with the direct route is, upgrading a Service Pack in...
July 15, 2014 at 2:32 pm
Noam Graizer (7/15/2014)
finally we found the correct solution:after you remove file from the DB, you have to backup log
this reset the sys.database_files table
now we successed to add files ...
For...
July 15, 2014 at 1:43 pm
Rudyx - the Doctor (7/15/2014)
I would just apply 2005 SP4 as a part of the process then go to 2012.This way you avoid any 'potential' licensing issues.
In between this is...
July 15, 2014 at 1:41 pm
Chowdary's (7/11/2014)
T.log can not be restored on the secondary Database which is due to that transaction log sequence is broken.in that time what we will check & do .
Please...
July 15, 2014 at 8:14 am
very easy to do on a maintenance window and also checks that you still know how to perform this action
😉
July 15, 2014 at 8:06 am
It's one alter command per file when modfying, never been a bother for me
you're only typing multiple alter statements, not as if it's a hardship 😉
ALTER DATABASE somedb MODIFY FILE
What...
July 15, 2014 at 8:04 am
nvalia (7/14/2014)
Current SQL Server Details-
Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on...
July 15, 2014 at 7:55 am
khott (8/8/2013)
July 15, 2014 at 7:48 am
since a restart of the instance is necessary i would recommend you just remove the file at your next maintenance window. Start the instance single user and remove it.
Note this...
July 15, 2014 at 7:10 am
Noam Graizer (7/15/2014)
I can re-do this "alter database ...remove file" and this leaves the rows in the sys.database_files !!!
OOO !!!
I don't know what...
July 15, 2014 at 5:17 am
Viewing 15 posts - 3,166 through 3,180 (of 9,253 total)